MySQL Tutorial from Terminal 4/27: Adding / Deleting Users




My web page: www.imperial.ac.uk/people/n.sadawi.

Original source


5 responses to “MySQL Tutorial from Terminal 4/27: Adding / Deleting Users”

  1. insert into user
    (host,user,password,
    select_priv,insert_priv,update_priv)
    values('localhost','johan','000','Y','Y','Y');
    ============================
    Unknown column 'password' in 'field list' !!!!
    ============================
    insert into user
    (host,user,
    select_priv,insert_priv,update_priv)
    values('localhost','johan','Y','Y','Y');
    ============================
    Field 'ssl_cipher' doesn't have a default value
    ============================
    Could anyone explain this please !!

  2. I keep getting an error. Can you please help?

    Harshs-MacBook-Pro:~ harshpatel$ sudo /usr/local/mysql/support-files/mysql.server start
    Starting MySQL
     SUCCESS! 
    Harshs-MacBook-Pro:~ harshpatel$ show database
    -bash: show: command not found
    Harshs-MacBook-Pro:~ harshpatel$ show databases
    -bash: show: command not found
    Harshs-MacBook-Pro:~ harshpatel$ 

    ^ that is what happens in my terminal. I need to use SQL to create some tables.

Leave a Reply