jika Error nya 10038
\nsolusi ini berarti ada bind di my.cnf atau di mysqld.cnf
\nlangkah silahkan login ke putty atau winscp lakukan edit pada my.cnf atau mysqld.cnf dan kasih tanda # pada baris ini<\/p>\n
bind 172.0.0.1<\/p>\n
menjadi<\/p>\n
#bind 127.0.01<\/p>\n
restart mysql seharusnya sucsesfull conectuion<\/p>\n
jika errornya 2059
\nini karena user mysql ada yang haris di nonaktfkan<\/p>\n
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.<\/strong><\/p>\n The solution is to change the verification method to the verification method mysql_native_password used in previous versions (5.7 and below).<\/strong><\/p>\n Langkah nya silahkan login ke mysql di server dengan terminal Welcome to the MySQL monitor. Commands end with ; or \\g. Copyright (c) 2000, 2025, Oracle and\/or its affiliates.<\/p>\n Oracle is a registered trademark of Oracle Corporation and\/or its Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n mysql> ALTER USER ‘pusikom’@’%’ IDENTIFIED WITH mysql_native_password BY ‘password’;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0(ini adalah user yang akan di pakai oleh navicat ke mysql) mysql> FLUSH PRIVILEGES; mysql> quit coba lakukan conecsi lagi dengan navicat seharusnya successfull<\/p>\n","protected":false},"excerpt":{"rendered":" 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 […]<\/p>\n","protected":false},"author":2,"featured_media":9327,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-9326","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts\/9326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9326"}],"version-history":[{"count":1,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts\/9326\/revisions"}],"predecessor-version":[{"id":9328,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts\/9326\/revisions\/9328"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/media\/9327"}],"wp:attachment":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nroot@ubuntu72:~#mysql -u root -p\u00a0 (enter)
\nroot@ubuntu72:~# (masukkan pasword root mysql)
\nroot@ubuntu72:~#<\/p>\n
\nYour MySQL connection id is 1910
\nServer version: 8.0.42-0ubuntu0.24.04.1 (Ubuntu)<\/p>\n
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n
\nQuery OK, 0 rows affected (0.08 sec)<\/p>\n
\nQuery OK, 0 rows affected (0.03 sec)<\/p>\n
\nBye<\/p>\n