Portal Home > Knowledgebase > Articles Database > How to Grant All Privileges to a database Centos?
How to Grant All Privileges to a database Centos?
| Posted by -liquid-, 09-19-2014, 05:59 PM |
| Hello i am using Centos 6 64..
I have a database called examples test_db.sql and a username testuser
I want to Grant All Privileges to the whole database and the user how can i do this via SSH.. ?? Thank you!
|
| Posted by K&T Host - Tim, 09-19-2014, 07:21 PM |
| Hello,
I am assuming a Mysql server here. You would need to login to the Mysql server as a root user or other administrator first. Once you do, you can grant privileges to another user. See the following SQL to do so.
#Sql Code
grant all privileges on databasename.* to 'username'@'location' identified by 'password';
Replace databasename, username, location, and password as needed. I hope that helps.
|
| Posted by net, 09-19-2014, 07:32 PM |
| Moved > Hosting Security and Technology.
|
| Posted by Srv24x7, 09-20-2014, 10:48 AM |
| Hi,
Try using the below to grant all privileges to all DB
GRANT ALL PRIVILEGES ON *.* TO ''@'localhost';
|
| Posted by prashant1979, 09-21-2014, 03:27 AM |
| You can easily do it from cPanel. You have to login to the cPanel account and under the MySQL Databases, you can assign permissions to the database user.
|
| Posted by johnduper, 09-21-2014, 04:02 AM |
| make sure you have sufficient privileges
|
Add to Favourites 
Print this Article
Also Read
