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