×
Create a new article
Write your page title here:
We currently have 3,189 articles on s23. Type your article name above or create one of the articles listed here!



    s23
    3,189Articles

    ->MySQL->Create User

    Dont use mysql-root because of lazyness ;) (set root pw with UPDATE mysql.user SET Password=PASSWORD("new_password") WHERE User="root";) -> MySQL#Setting_the_initial_root_password

    Create a new user "fnord" with password "foobar".:

    INSERT INTO mysql.user (user, host, password)
       VALUES ('fnord', 'localhost', PASSWORD('foobar'));
    

    Create a new database "grudnuk":

    CREATE DATABASE grudnuk;
    

    Give permissions to the user "fnord" on all tables of the db "grudnuk":

    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP
       ON grudnuk.* TO fnord;
    

    Dont forget to update permissions:

    FLUSH PRIVILEGES;
    
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.