[BlueOnyx:04291] Re: MySQL/phpmyadmin error

[Gerald Waugh]

On Sun, 2010-04-18 at 09:37 -0500, Don Teague 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)

CREATE DATABASE test1;

GRANT USAGE ON * . *
  TO 'root'@'%'
  IDENTIFIED BY '<root-password>'
  WITH MAX_QUERIES_PER_HOUR 0
       MAX_CONNECTIONS_PER_HOUR 0
       MAX_UPDATES_PER_HOUR 0 ;

GRANT ALL PRIVILEGES ON `test1` . *
  TO 'root'@'%' WITH GRANT OPTION ;
FLUSH PRIVILEGES;

show databases;