May 16 2025
Connect Navicat ke Mysql Server
jika Error nya 10038
solusi ini berarti ada bind di my.cnf atau di mysqld.cnf
langkah silahkan login ke putty atau winscp lakukan edit pada my.cnf atau mysqld.cnf dan kasih tanda # pada baris ini
bind 172.0.0.1
menjadi
#bind 127.0.01
restart mysql seharusnya sucsesfull conectuion
jika errornya 2059
ini karena user mysql ada yang haris di nonaktfkan
A 2059 error will occur when using navicat to connect to MySQL8. This is because the new version of MySQL uses the caching_sha2_password authentication method, but at this time Navicat does not yet support this verification method.
The solution is to change the verification method to the verification method mysql_native_password used in previous versions (5.7 and below).
Langkah nya silahkan login ke mysql di server dengan terminal
root@ubuntu72:~#mysql -u root -p (enter)
root@ubuntu72:~# (masukkan pasword root mysql)
root@ubuntu72:~#
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1910
Server version: 8.0.42-0ubuntu0.24.04.1 (Ubuntu)
Copyright (c) 2000, 2025, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> ALTER USER ‘pusikom’@’%’ IDENTIFIED WITH mysql_native_password BY ‘password’; (ini adalah user yang akan di pakai oleh navicat ke mysql)
Query OK, 0 rows affected (0.08 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.03 sec)
mysql> quit
Bye
coba lakukan conecsi lagi dengan navicat seharusnya successfull