Control Web Panel
WebPanel => MySQL => Topic started by: satria on September 05, 2015, 07:08:52 AM
-
hello all,
i was success create user and database
now how to add PRIVILEGES the user i created to the database ?
because when i was import the dump sql file with phpmyadmin.
and when i open my website i got error
"Could not connect to mysql! Please check your database settings!"
please help me
-
Hello.
It will be added in a new release.
Now you should do that from PhpMyAdmin or MySQL monitor
-
Atleast can you please guide how to do from there, as i m not able to do this, i m also getting same problem, created database, user but it has no permission, it says - The server responded with the following error message: Access denied for user 'mysql_mysite'@'localhost' to database 'mysitene_mysite'
Can anyone help
-
Yes I also have exactly the same problem. Created the users but now cannot do anything with them to create/import tables. Spent most of Friday faffing around trying to sort this out to no avail. Can't login as root as I would have normally as it looks like the password has been set and I have no idea what it is (nor does the hosting co either apparently). This really needs to be covered in the FAQ's. How does everyone else get around this as I would imagine anyone wanting to use a mysql database set up through CWP has hit the same issue... havent they? Looking forward to a solution. CWP has great potential its just missing a few fundamentals for me.
-
I've solved my issue by shelling in and following this tutorial... https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql