MySql运行相关命令

    1. #查看mysql的运行状态
    2. service mysql status
    3. #运行mysql
    4. service mysql start
    5. #重新运行
    6. service mysql restart
    7. #停止mysql
    8. service mysql stop

    MySql登录

    #账号密码登录
mysql -u root -p
#修改当前登录的账号的密码
set password = password('123456');
#修改mysql给远程登录使用
Grant all privileges on *.* to "root"@"%" identified by "数据库密码" with grant option;
#刷新数据
flush privileges