Create a new user (‘meeg’) in MySQL

  1. Open Terminal and type:

    /usr/local/mysql/bin/mysql --user=root mysql

    10.4-8


  2. Type the following line in MySQL Shell:

    GRANT ALL PRIVILEGES ON *.* TO 'meeg'@'%';

    (the final semicolon is essential!) and press return.

    Now type:

    GRANT ALL PRIVILEGES ON *.* TO 'meeg'@'localhost';

    and press return.

    10.4-9


  3. If you want to set a password for the database user ‘meeg’ please use this two queries following the previous ones or in place of them:

    GRANT ALL PRIVILEGES ON *.* TO 'meeg'@'localhost' IDENTIFIED BY 'YourPassword' WITH GRANT OPTION;

    GRANT ALL PRIVILEGES ON *.* TO 'meeg'@'%' IDENTIFIED BY 'YourPassword' WITH GRANT OPTION;

  4. Finally, type ‘quit’ and hit return to exit from the MySQL Shell

To complete the installation open System preference / sharing and (re)start the personal web sharing.