歡迎您光臨本站 註冊首頁

Linux下MySQL的管理與配置

←手機掃碼閱讀     火星人 @ 2014-03-09 , reply:0
1. MySQL服務的啟動:service mysqld start
2. 進入MySQL:mysql
3. 退出MySQL:exit 或者 q
4. 初次登錄並設置密碼:
$ mysql -u root
mysql> SET password=PASSWORD( 'password' );
5. 再次登錄命令:mysql -u root -p
6. 查詢用戶密碼:select user, host, password from mysql.user;
7. 更改密碼:
> UPDATE user SET password=PASSWORD( 'new password' ) WHERE user='user name';
> FLUSH PRIVILEGES;
> QUIT
8. 更改密碼二:
> SET PASSWORD FOR user name=PASSWORD('new password');
> QUIT


[火星人 ] Linux下MySQL的管理與配置已經有253次圍觀

http://coctec.com/docs/linux/show-post-55073.html