Print

[pushback]

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!

 

[ron4mac]

Did you GRANT PRIVILEGES for the username that you are using? Try connecting manually to the 'cpgff' database as that user. Does that work?

[pushback]

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!

[pushback]

Is all good now.  Had to read up on granting privs a bit.  Thanks for sending me down the path.

[Αndré]

Marking as solved.