How to add database user

m
m
 
Line 1: Line 1:
 
<seo title="How to add user" metakeywords="add user,new database user,create database user" metadescription="How to add user" />
 
<seo title="How to add user" metakeywords="add user,new database user,create database user" metadescription="How to add user" />
  
To add a user to your DB you need to go to cPanel => 'Databases' and look for the following form:
+
<div align="justify">To add a user to your DB you need to go to '''cPanel''' of your [http://myidealhost.com/hosting.shtml hosting account] then click on '''MySQL Databases''' and look for the following form:
  
 +
{{#icon: How to add user.png|How to add database user}}
  
----
 
  
{{#icon: How to add user.png|How to add database user}}
+
There you are to type the name of the new user you want to add. Once it is done click on '''Create User'''.
  
----
+
After the new database user is created you need to add it to the DB. Just choose the DB and user needed from the pull-down menus and click on '''Add'''
  
There you are to type the name of the new user you want to add. Once it is done click on 'Create User'.
 
  
After the new database user is created you need to add it to the DB. Just choose the DB and user needed from the pull-down menus and click on 'Add'
+
{{#icon: How to add database user.png|How to add database user}}
  
----
 
  
{{#icon: How to add database user.png|How to add database user}}
+
Then you'll be forwarded to the page allowing you to set the privileges for the added user. Here you can set either partial privileges or all of them (by checking '''All Privileges''' box at the top).
  
----
 
  
Then you'll be forwarded to the page allowing you to set the privileges for the added user. Here you can set either partial privileges or all of them (by checking 'All Privileges' box at the top).
+
{{#icon: Privileges.png|How to set privileges}}
  
----
 
  
{{#icon: Privileges.png|How to set privileges}}
+
Done. Now you know how to create a database user over cPanel of your MyIdealHosting [http://myidealhost.com/hosting.shtml web hosting account].</div>
  
----
+
Also see '''''[[How to create secure password]]'''''
 
+
Done. Now you know how to create a database user.
+

Latest revision as of 12:08, 29 October 2012

rss feed for my website