MySQL Tutorial from Terminal 4/27: Adding / Deleting Users d4mer MySQL December 30th, 2018 5 Comments 187 views My web page: www.imperial.ac.uk/people/n.sadawi. Original source Tags mysql tutorial Share : tweet Previous Next About the : d4mer Related Posts sistema biblioteca php Mysql(CODIGO FUENTE GRATIS) April 12th, 2019 Apache, PHP & MySql on Docker April 11th, 2019 Python Flask and Vue Tutorial – Video 1 April 11th, 2019 Importing MySQL Database April 11th, 2019 sistema escolar php y mysql Codigo Fuente Gratis April 10th, 2019 Connecting to MySQL database on Wampserver from any host (Computer) April 10th, 2019 5 Comments True Event December 30, 2018 at 00:55Log in to Reply 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-osxbut can't do it (just no updates) GoldPhoenix99 December 30, 2018 at 00:55Log in to Reply 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. Uday Sai Kumar December 30, 2018 at 00:55Log in to Reply Your tutorials are good but there is a lot of disturbance I didn't clearly understand sometimes due to that disturbance. bisho faheem December 30, 2018 at 00:55Log in to Reply 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 !! galemoy December 30, 2018 at 00:55Log in to Reply I keep getting an error. Can you please help? Harshs-MacBook-Pro:~ harshpatel$ sudo /usr/local/mysql/support-files/mysql.server startStarting MySQL SUCCESS! Harshs-MacBook-Pro:~ harshpatel$ show database-bash: show: command not foundHarshs-MacBook-Pro:~ harshpatel$ show databases-bash: show: command not foundHarshs-MacBook-Pro:~ harshpatel$ ^ that is what happens in my terminal. I need to use SQL to create some tables. Leave A Comment Click here to cancel reply. You must be logged in to post a comment.