I'm having a problem to change to MySQL. My domain is hosted on a shared (virtual) server, so my database name is mydomain_com_gedview, where only gedview is my choice.
I have the ability to create new users, so I created MySQL user: gedview with the same password.
If I try to configure the change to mySQL using user gedview, I am rejected as not being able to connect to the database. OK, so perhaps I don't have all the permissions, but when I use my full DB username and password, then phpGedView config shows this error:
-----------------------------------
Welcome to your new PhpGedView website. Since you are seeing this page you have successfully installed PhpGedView on your webserver and are ready to begin configuring it the way you want it.
Here dbconn:Resource id #16 dbsel: dbuser: user dbpass: pass Your current database configuration is bad. Please check your database connection parameters and configure again.
PhpGedView made a connection to your MySQL database host, but was unable to use the database with the name you entered. Check that the database exists and that the usename you entered has the appropriate permissions on that database.
----------------------------------
I'm not very good with reading the source. I thought the db name maybe too long, but it appears to be a 40char string, which is ample.
Any ideas?
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Your database configuration should look something like this:
MySQL Host: localhost
MySQL Database Name: mydomain_com_gedview
MySQL User: gedview
MySQL Password: gedview
The user must have create rights on the mydomain_com_gedview database. Now that you have created the user, gedview, it must have the correct privileges. The following SQL command will give the gedview user all rights on the system:
GRANT ALL PRIVILEGES ON mydomain_com_gedview.* TO gedview@localhost IDENTIFIED BY 'password';
You either need to run this command or find other ways to give the user database privileges. Since you can create database users, you probably already have a user that has the full access privileges. You could also try to use the username and password of that user.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm having a problem to change to MySQL. My domain is hosted on a shared (virtual) server, so my database name is mydomain_com_gedview, where only gedview is my choice.
I have the ability to create new users, so I created MySQL user: gedview with the same password.
If I try to configure the change to mySQL using user gedview, I am rejected as not being able to connect to the database. OK, so perhaps I don't have all the permissions, but when I use my full DB username and password, then phpGedView config shows this error:
-----------------------------------
Welcome to your new PhpGedView website. Since you are seeing this page you have successfully installed PhpGedView on your webserver and are ready to begin configuring it the way you want it.
Here dbconn:Resource id #16 dbsel: dbuser: user dbpass: pass Your current database configuration is bad. Please check your database connection parameters and configure again.
PhpGedView made a connection to your MySQL database host, but was unable to use the database with the name you entered. Check that the database exists and that the usename you entered has the appropriate permissions on that database.
----------------------------------
I'm not very good with reading the source. I thought the db name maybe too long, but it appears to be a 40char string, which is ample.
Any ideas?
Thanks!
Your database configuration should look something like this:
MySQL Host: localhost
MySQL Database Name: mydomain_com_gedview
MySQL User: gedview
MySQL Password: gedview
The user must have create rights on the mydomain_com_gedview database. Now that you have created the user, gedview, it must have the correct privileges. The following SQL command will give the gedview user all rights on the system:
GRANT ALL PRIVILEGES ON mydomain_com_gedview.* TO gedview@localhost IDENTIFIED BY 'password';
You either need to run this command or find other ways to give the user database privileges. Since you can create database users, you probably already have a user that has the full access privileges. You could also try to use the username and password of that user.
--John