• Tuesday , 26 May 2020

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

Code Canyon



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

Original source

3d Ocean

Related Posts

5 Comments

  1. True Event
    December 30, 2018 at 00:55

    Hi Noureddin, I have a proiblem – I don't have a field "password" in user table… I try to solve this problem with next tutorial: https://stackoverflow.com/questions/30692812/mysql-user-db-does-not-have-password-columns-installing-mysql-on-osx
    but can't do it (just no updates)

  2. GoldPhoenix99
    December 30, 2018 at 00:55

    You used mysql code ("INSERT INTO user") that was deprecated 3 versions of MySQL ago (You're using version 5.x.x, it was deprecated in version 3.x.x), and now all of this code is borked.

  3. Uday Sai Kumar
    December 30, 2018 at 00:55

    Your tutorials are good but there is a lot of disturbance I didn't clearly understand sometimes due to that disturbance.

  4. bisho faheem
    December 30, 2018 at 00:55

    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 !!

  5. galemoy
    December 30, 2018 at 00:55

    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 Comment

You must be logged in to post a comment.