Simple steps to create a database for mysql for use with wordpress or any other program

Hits: 355

Working on server with shell access.

  • mysql -u yourusernamewithadminrights -p;
  • create database yournewdatbasename;

For security you should make a new user with a different password for each database . This will keep it secure like  submarine. If one program and db are cracked the others should be safe

To create and grant privileges to a user now being created 

  • CREATE USER ‘youruser’@’localhost’ IDENTIFIED BY ‘yourpassword’;
  • GRANT ALL PRIVILEGES ON  yourdb.* to ‘youruser’@’localhost’