Skip to content

mysql.md

Latest commit

 

History

History
19 lines (17 loc) · 697 Bytes

mysql.md

File metadata and controls

19 lines (17 loc) · 697 Bytes

creat table

CREATE TABLE IF NOT EXISTS runoob_tbl( runoob_id INT UNSIGNED AUTO_INCREMENT, runoob_title VARCHAR(100) NOT NULL, runoob_author VARCHAR(40) NOT NULL, submission_date DATE, PRIMARY KEY ( runoob_id ) )ENGINE=InnoDB DEFAULT CHARSET=utf8;

~/.bash_profile

    PATH=$PATH:/usr/local/mysql/bin  
    source  ~/.bash_profile

update user set Password=OLD_PASSWORD('password') WHERE User='username'; update user set authentication_string=OLD_PASSWORD('password') WHERE User='username'; update user set authentication_string=password(''), plugin='mysql_native_password' where user='root'; https://dev.mysql.com/doc/refman/5.5/en/old-client.html