1.登錄mysql mysql -u root -p密碼 2.退出mysql exit 3.切換mysql數(shù)據(jù)庫(kù) use 數(shù)據(jù)庫(kù)名 4.查看全部數(shù)據(jù)庫(kù) show databases; 5.新建數(shù)據(jù)庫(kù) create database 數(shù)據(jù)庫(kù)名; 6.刪除數(shù)據(jù)庫(kù) drop database 數(shù)據(jù)庫(kù)名; 7.顯示所有表 show tables; 8.顯示表結(jié)構(gòu) describe 表名; 9.root密碼丟失重置方法 /etc/rc.d/init.d/mysql stop /usr/local/mysql/bin/mysqld_safe --skip-grant-table& /usr/local/mysql/bin/mysql -u root mysql> use mysql mysql> UPDATE user SET password=password('newpassword') WHERE user='root'; mysql> FLUSH PRIVILEGES; 重啟 |
聯(lián)系客服