phpmyadmin password lost

M

max2000

Verified User
Joined
Nov 7, 2004
Messages
141
Location
Europe
Hi,

One of my customers on a dedicated server lost his main mySQL password.

Initially the login to mySQL was with the same password as directadmin.

The customer changed his main DA password, but in :

/usr/local/directadmin/conf/mysql.conf

there is allways the old directadmin password. I tried to use it to login or even to change it but this doesn't work.

Is there any way to change the mysql for da_admin for SSH?

Thank you for your help
 
Thank you for your kind concern. Yes mySQL still works but we can't manage it as we have no password.

I will use the totorial right now.
 
The lines

service mysqld stop (Redhat)
mysqld_safe --skip-grant-tables &

Are ok.

But when I type

use mysql

I return to the prompt with

-bash: use: command not found

Have any idea?

The server uses Fedora Core 2
 
"use mysql" is actually a mysql command.

After you restart mysql, you'll want to run the mysql command line client: "mysql"

Then you'll end up at a mysql command prompt, e.g.
Code: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20627 to server version: 4.0.24-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
at which point you can continue with the "use mysql" section.
 
While in that mode it is also possible to change other acount passwords, however it is probably easier to get DirectAdmin and/or phpmyadmin working and do it to any other necassary accounts with an interface.
 
You must log in or register to reply here.
Back
Top