mysql退出命令：\c番川，強(qiáng)制退出：control+c
bash: mysql: command not found
原因：因?yàn)閙ysql命令的路徑在/usr/local/mysql/bin下面,所以直接用mysql命令時(shí),
系統(tǒng)在/usr/bin下面查此命令,所以找不到了。
解決辦法：ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
提示無權(quán)限个从，加sudo侣监。
但是在mac os x ei capitan 系統(tǒng)中加sudo還是提示無權(quán)限鸭轮，
原因：ei capitan中加入了Rootless機(jī)制，不再能夠隨心所欲的讀寫很多路徑下了橄霉。設(shè)置 root 權(quán)限也不行窃爷。
解決辦法：增加mysql別名
alias mysql=/usr/local/mysql/bin/mysql
同樣，也可以給mysqladmin增加一樣的別名
alias mysqladmin=/usr/local/mysql/bin/mysqladmin
進(jìn)入mysql命令行模式
mysql -u root -p
如果看到下面的提示表示已經(jīng)登錄成功姓蜂。
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 346
Server version: 5.7.11 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
修改密碼和設(shè)置有效期
修改mysql 賬戶密碼按厘，修改的是當(dāng)前登錄的帳戶密碼
SET PASSWORD = PASSWORD('your new password');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;
