Author Topic: how to add PRIVILEGES user  (Read 14681 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
how to add PRIVILEGES user
« 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

Offline
*****
Re: how to add PRIVILEGES user
« Reply #1 on: September 11, 2015, 07:05:06 PM »
Hello.

It will be added in a new release.
Now you should do that from PhpMyAdmin or MySQL monitor
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: how to add PRIVILEGES user
« Reply #2 on: September 18, 2015, 06:53:13 PM »
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

Offline
*
Re: how to add PRIVILEGES user
« Reply #3 on: September 19, 2015, 08:41:00 AM »
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.

Offline
*
Re: how to add PRIVILEGES user
« Reply #4 on: September 19, 2015, 10:48:59 AM »