Differences

This shows you the differences between two versions of the page.

Link to this comparison view

howto:create_database_and_user_in_mysql [2015/01/29 09:52] (current)
yehuda created
Line 1: Line 1:
 +====== Create database and user in MySQL ======
  
 +
 +<code sql>
 +-- Access via shell $ mysql -u root -p
 +
 +-- Create DB 
 +CREATE DATABASE databasename;​
 +
 +-- Create User
 +GRANT ALL PRIVILEGES ON databasename.* TO "​wordpressusername"​@"​%"​ IDENTIFIED BY "​password";​
 +  ​
 +-- Flush
 +FLUSH PRIVILEGES;
 +
 +-- exit
 +EXIT
 +</​code>​
howto/create_database_and_user_in_mysql.txt ยท Last modified: 2015/01/29 09:52 by yehuda
Back to top
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0