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.
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 !!
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.
5 responses to “MySQL Tutorial from Terminal 4/27: Adding / Deleting Users”
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)
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.
Your tutorials are good but there is a lot of disturbance I didn't clearly understand sometimes due to that disturbance.
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 !!
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.