forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 install => Topic started by: pushback on October 12, 2014, 01:14:57 am
-
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.