« Adduser mysql with phpmyadmin (buat sTreZ)
Insert Image »

Menghadapi Error pada phpmyadmin

Lu pernah gak ketika pertama kali install phpmyadmin trus waktu lu login terjadi error semacam ini?:

ERROR 2002: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

aq punya sedikit crita ketika aku install phpmyadmin pertama kali di server ini. gak nyangka ngga dinyana, biasanya sih aq ga pernah ngalamin error yang kayak tadi. padahal kalo aq coba login mysql lewat shell, eh bisa low.. tapi kok kalo lewat phpmyadmin ga bisa ya? apa yang salah? bingung punya bingung akhirnya aq coba cari aja di google. eh ternyata banyak juga sih kasus2 seperti ini, namun sayangnya, kesalahan yang terjadi gak sepenuhnya sama persis, akhirnya aq coba experiment sesuai petunjuk dari web forum yang kutemukan.

seperti yang kubaca di forum tadi, kalo kita ngadepin eror spt tadi, lu ketik aja ini di shell:

Login as root,

root@xbox:/usr/local/mysql# scripts/mysql_install_db
Installing all prepared tables
031218 9:42:37 ./bin/mysqld: Shutdown Complete

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root password ‘new-password’
./bin/mysqladmin -u root -h xbox.oh.rik password ‘new-password’
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the ’sql-bench’ directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Abis pesan ini nih, aq coba lagi login lewat phpmyadmin, walah… ternyata gak bisa juga sodara. error masih tetap ada. binung punya bingung akhirnya aku coba linkan mysql.sock

ln -s /var/lib/mysql/mysql.sock /tmp

abis itu aq coba lagi. ealah… ternyata.. malah bisa. dudul juga ternyata. tak taunya cuman gara2 di /tmp gak ada

Check that mysqld is running and that the socket: ‘/tmp/mysql.sock’ exists!

udah ya.. critanya kita lanjut kapan2 lagi..

Popularity: 1% [?]

#2002 cannot log in to the mysql server, , phpmyadmin terjadi error mysql said cannot connect, error code: 2002 error: cant connect to local mysql server through socket /var/run/mysqld/mysqld sock (2), inurl : / phpmyadmin, phpmyadmin #2002 cannot log in to the mysql server, phpmyadmin cannot log in to the mysql server, tidak bisa masuk phpmyadmin, #2002 cannot log in to the mysql server-iis7, #2002 cannot log into the mysql server, #2002 phpmyadmin error iis, cannot log in to the mysql server root, cant connect to local mysql server through socket /var/run/mysqld/mysqld sock (2, cant connect to local mysql server through socket /var/run/mysqld/mysqld sock (2), cant login to phpmyadmin, cara #2002 cannot log in to the mysql server, connect phpmyadmin with password\, error #2002, error 2002: cant connect to local mysql server through socket /tmp/mysql sock (2), error 2002:can’t connect to local mysql server through socket ‘/tmp/mysql sock’(2), error cannot log in to the mysql server, error pada mysqld -nt, f, got error: 2002: cant connect to local mysql server through socket /tmp/mysql sock, how to configure phpmyadmin error #2002, iis 7 2002 cannot log in to the mysql server, intitle=/tmp/mysql sock, inurl:/phpmyadmin/ root@ -denied site:id, inurl:phpmyadmin as root@* -thread -html, inurl:phpmyadmin site:id, kenapa phpmyadmin the server cannot responding, kenapa web cant connect to local mysql server through socket /var/run/mysqld/mysqld sock (2), ketika install script kenapa ada pesan error : cant connect to local mysql server through socket /var/run/mysqld/mysqld sock (2), login error phpmyadmin, login into phpmyadmin with password, masalah phpmyadmin - error #2002, mysql phpmyadmin not login, mysql sock, password masuk phpmyadmin, pesan #2002 cannot log into the mysql server, pesan error pada phpmyadmin, , phpmyadmin - error #2002, phpmyadmin can not log in to mysql serve, phpmyadmin cannot login, phpmyadmin error cannot connect, phpmyadmin error pada server, phpmyadmin install error, phpmyadmin root problem, phpmyadmin socket mysql

Related posts

Tags:

This entry was posted on Thursday, August 5th, 2004 at 5:59 am and is filed under Tutor. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Menghadapi Error pada phpmyadmin”

  1. badZ says:
    August 5, 2004 at 5:59 pm

    Yah.. namanya juga manusia. kalo ngga gini gak pinter2 hehehhe

  2. sTreZ says:
    August 5, 2004 at 2:04 pm

    Hahahaha…ternyata hal2 semacam itu bisa bikin error yah..cuma masalah /tmp ga ada..he9x..spt kata pepatah,karna nila setitik,rusak susu sebelanga..he9x…gara2 kesalahan kecil,bisa bikin error program..hidup saya !!!

Leave a Reply