«
»

MySQL creating a database and user from the console

Here is how to quickly create a database and add a user to a mysql database (the mysql console).
(Yes some values need to be changed)

  • mysql> use mysql;
  • mysql> CREATE DATABASE dbname;
  • mysql> INSERT INTO user (Host,User,Password) VALUES (‘localhost’, ‘username’, PASSWORD(‘password’));
  • mysql> GRANT ALL ON dbname.* TO ‘username’;
  • mysql> FLUSH PRIVILEGES;
  • mysql> exit

Update: This approch will not work when using MySQL server under Windows.

This entry was posted on Wednesday, March 24th, 2010 at 12:18 and is filed under MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “MySQL creating a database and user from the console”

  1. Naruto Ipod Thingy | Bad Credit - Loans, Repairs, Help, Mortgage news and information. says:
    2010 March 24 at 13:37

    [...] MySQL creating a database and user from the console « Jontas blog … [...]

  2. MySQL creating a database and user from the console « Jontas blog … says:
    2010 March 24 at 18:36

    [...] the original post: MySQL creating a database and user from the console « Jontas blog … Posted in Uncategorized | Tags: console, from-the-console, quickly-create, [...]

Leave a Reply