Use command not found

nvomedia

Verified User
Joined
Aug 17, 2015
Messages
12
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?

Code:
-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

Super Moderator
Joined
Apr 11, 2005
Messages
14,243
Location
GMT +7.00
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

Administrator
Staff member
Joined
Aug 22, 2006
Messages
8,891
Location
LT, EU
Please execute command "mysql" before executing "use mysql". It will open MySQL console where "use mysql" command will be recognized.
 
Top