linux登录退出mysql_Linux下mysql 登陆退出及经常使用命令

登陆

mysql -u用户名 -p                回车后输入密码mysql

退出sql

exit 或者 quit  或者 \q        数据库

经常使用命令服务器

mysqladmin -u用户名 -p旧密码 password新密码                            用来修改用户密码ui

showdatabases；                                                                                   显示全部数据库，注意后面的   ；.net

use 数据库名                                                                                             使用数据库blog

select  database();                                                                                   显示当前链接的数据库get

select version();                                                                                        显示当前服务器版本it

select now();                                                                                              显示当前日期io

select user();                                                                                               显示当前用户名