Hello, I'm part-way through an install of 1.5.32 and the installer does not see the database on localhost. I have tried via the wizard and via the regular installer. The error message is "MySQL could not locate a database called 'cpgff' please check the value entered for this." I have already crated the database manually on the server:
[root@flash etc]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 67
Server version: 5.5.37-MariaDB 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 |
| mysql |
| performance_schema |
| test |
+--------------------+
5 rows in set (0.00 sec)
MariaDB [(none)]>
I'm running on CentOS.
Thanks in advance!
Did you GRANT PRIVILEGES for the username that you are using? Try connecting manually to the 'cpgff' database as that user. Does that work?
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!
Is all good now. Had to read up on granting privs a bit. Thanks for sending me down the path.
Marking as solved.