var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
How do I grant privilege for MySQL on CentOS 5 32bit?
My VPS is running on CentOS 5 32bit with Kloxo installed.
I have created the database in Kloxo. But I can't seem to find information on how to grant privilege for the database.
I would like to grant all privilege to one of my databases, how do I do that?
Thank you in advance.
Nevermind. Figured it out. I didn't know I could do it through phpMyAdmin.
Nice to hear you figured out it. You can do it via command line as well.
You will start by logging into your server via ssh and logging into your MySQL entering the following:
mysql –u root –p
Your prompt should now look like this:
Enter the following:
GRANT SELECT ON database.* TO username@'localhost' IDENTIFIED BY 'password';
To enable more options you would separate them with a comma. So to enable SELECT, INSERT, and DELETE your
syntax would look like this;
GRANT SELECT, INSERT, DELETE ON database.* TO username@'localhost' IDENTIFIED BY 'password';
Once you have given the desired privileges for your user, you will need to run this command within the MySQL
To see a list of the privileges that have been granted to a specific user;
select * from mysql.user where User='user' \G
Before I found out I could grant privilege for MySQL through phpMyAdmin, I was looking for command prompts. But none of them worked.
I tried mysql –u root –p
There is no response. :/ I hit enter after finishing typing the prompt, but nothing shows up. I could still edit the prompt even after hitting enter.
I don't know if I am supposed to install MySql via Yum in the console or what. Some sites provide codes to install MySql but states only if there is no other software installed. Since I have already installed Kloxo (which has database management) I assumed that MySQL is installed. Please correct me if I am wrong.
Oh. I think my browser kept on getting stuck when I was accessing the console window, which is why the command prompt didn't go.
Thank you for the prompts !
By antondb in forum Dedicated Server
Last Post: 09-03-2008, 01:43 PM
By ckissi in forum Dedicated Server
Last Post: 01-30-2008, 08:32 PM
By ti_nhatrang in forum Hosting Software and Control Panels
Last Post: 09-26-2007, 06:09 AM
By TonyB in forum Hosting Security and Technology
Last Post: 06-08-2005, 01:49 AM
By hostchamp in forum Hosting Security and Technology
Last Post: 02-15-2005, 03:12 PM