Create New MySQL Database And Assign Administrator

By Chris Koehler | Published: May 2, 2007

Create New Database
create database <database>;

Create Administrator Account
grant all on <database>.* to ‘<user>’@'localhost’ identified by ‘<password>’;

Reset Privileges
flush privileges;

This entry was posted in MySQL. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  • 4.0 (5)
    4.1 (3)
    CentOS (4)
    FastCGI (4)
    Lighttp (3)
    Linux (2)
    MySQL (5)
    Network (1)
    PHP (2)
    Rails (4)
    Ruby (6)
    S3 (1)
    Search Engine Optimization (1)
    Unix (2)
    VMWare (2)
    Web Services (2)
    WordPress (1)

    WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

  • Categories

  • Recent Posts