Yes, I granted all privileges to that username. I can't even get it to authenticate at the command line:
[root@flash www]# mysql -u fred -p
Enter password:
ERROR 1045 (28000): Access denied for user 'fred'@'localhost' (using password: YES)
The password is good. I've checked it, reset it, checked it again .... it's good.
When I login with no user I can see all the databases I've created:
[root@flash www]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 193
Server version: 5.5.37-MariaDB-log MariaDB Server
Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cpgff |
| galleryff |
| mysql |
| performance_schema |
| test |
+--------------------+
7 rows in set (0.00 sec)
But when I remove the password from my fred user and login as fred I cannot see those databases:
[root@flash www]# mysql -u fred
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 217
Server version: 5.5.37-MariaDB-log MariaDB Server
Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)
MariaDB [(none)]>
I'd like to be able to login with the username 'fred' and gain access to those databases. Any help is appreciated!