Use command not found

[nvomedia]

Hi,

I'm unable to create databases in DirectAdmin. After a failed try to upgrade MySQL (See http://forum.directadmin.com/showthread.php?t=51883) DA says 'Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: YES)'.

I have tried the repair guide on http://help.directadmin.com/item.php?id=45 but when I type use mysql it says '-bash: use: command not found'.
What is going wrong?

-bash-3.2# /etc/init.d/mysqld stop
Shutting down MySQL SUCCESS!
-bash-3.2#  mysqld_safe --skip-grant-tables &
[1] 32228
-bash-3.2# Starting mysqld daemon with databases from //var
STOPPING server from pid file //var/web01.totalblue.nl.pid
150822 11:58:02  mysqld ended

use mysql
-bash: use: command not found
[1]+  Done                    mysqld_safe --skip-grant-tables
-bash-3.2#

 

[zEitEr]

Hello,

If your server does not accept da_admin's password you could try to use root's password from /usr/local/directadmin/scripts/setup.txt. If MySQL does not accept root's password as well as any other login/password, then it would mean its User table is corrupted, and you might need to reinstall MySQL 5.0 from a scratch and restore all the tables from backups.

Please contact me for the MySQL upgrade if you are interested.

 

[smtalk]

Please execute command "mysql" before executing "use mysql". It will open MySQL console where "use mysql" command will be recognized.