phpMyAdmin Cannot Connect to MySQL

[frednoob]

Hello all,

I use DA control panel to create database, success.
When I open phpmyadmin to connect using database username and password, it said wrong password, I try connect using root and da_admin user and password, still cannot connect.

I search KB and found this http://help.directadmin.com/item.php?id=45, but when i follow step 2, it look weird.

[root@server ~]# service mysqld stop
Shutting down MySQL. [ OK ]
[root@server ~]# mysqld_safe --skip-grant-tables & use mysql
[1] 3092
-bash: use: command not found
[root@server ~]# Starting mysqld daemon with databases from /var/lib/mysql
[root@server ~]# UPDATE user SET password=PASSWORD('123qweasdzxc') WHERE user='root';
-bash: syntax error near unexpected token `('
[root@server ~]#

then i surf forum and found this http://directadmin.com/forum/showthread.php?t=24417

i try follow this step and success connect from command line ....

what next should i do ???

blank already ....

 

[GXX]

After this:

mysqld_safe --skip-grant-tables

It will drop you into a mysql prompt. Then you issue:

use mysql

Copy as the guide in the help page says. Do not combine mysqld_safe --skip-grant-tables -AND- use mysql.

 

[frednoob]

i follow your method, but look like no mysql prompt;

[root@server ~]# service mysqld stop
Shutting down MySQL. [ OK ]
[root@server ~]# mysqld_safe --skip-grant-tables
Starting mysqld daemon with databases from /var/lib/mysql

then blank line ....... how long it should appears ??

when i check folder /var/lib/mysql/

[root@server mysql]# ls
admin_rc server-bin.000001 server-bin.000008 server-bin.000015
da_roundcube server-bin.000002 server-bin.000009 server-bin.000016
ibdata1 server-bin.000003 server-bin.000010 server-bin.000017
ib_logfile0 server-bin.000004 server-bin.000011 server-bin.index
ib_logfile1 server-bin.000005 server-bin.000012 server.direct.ws.err
mysql server-bin.000006 server-bin.000013 server.directr.org.err
mysql.sock server-bin.000007 server-bin.000014 server.directr.org.pid
[root@server mysql]#

i see my database is there .... admin_rc ....

 

[GXX]

You forgot the '&' at the end of 'mysqld_safe --skip-grant-tables'.

Again, follow the guide exactly as it says. Don't forget anything and don't combine anything. Just copy and paste...

 

[frednoob]

same.......... no mysql prompt

[root@server ~]# uptime
09:56:25 up 3 min, 1 user, load average: 0.11, 0.37, 0.18
[root@server ~]# service mysqld stop
Shutting down MySQL. [ OK ]
[root@server ~]# mysqld_safe --skip-grant-tables &
[1] 3095
[root@server ~]# Starting mysqld daemon with databases from /var/lib/mysql

[root@server ~]#

 

[frednoob]

still waiting any solutions here ......