Create database and user in MySQL

-- 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
howto/create_database_and_user_in_mysql.txt · Last modified: 2022/01/03 16:03 by 127.0.0.1
Back to top
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0