[BlueOnyx:04292] Re: MySQL/phpmyadmin error

[Don Teague]

Guess I should have mentioned that I do have the mysql table from the
DB backup the night before. I can see the usernames for the other DB's
in there..

mysql -u root -ppasswordofmysql < mysql.mysqldump.sql

If I simply restore that database, wouldn't things go back to normal?
Still don't understand why people are having me reset root, when I can
get in via the command line ... strikes me a GUI problem or something
else...

On Sun, Apr 18, 2010 at 9:37 AM, Don Teague <blueonyx at donteague.com> wrote:
> So, uh ... anyone think this might have something to do with it?
>
> (Please note: All sites on the server are *STILL* UP and running ..
> they are NOT down ... I simply can't access them, or create databases
> in phpmyadmin.
>
> [root at bx2 /]# mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 231
> Server version: 5.0.77 Source distribution
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | test               |
> +--------------------+
> 2 rows in set (0.01 sec)
>