Mysql连接、启动和关闭

1.linux下连接mysql出现：mysql-ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

估计密码错误

解决方式：启动mysqld_safe 进行免密登录

进入mysql安装目录

cd /usr/local/mysql/bin

启动mysqld_safe

sh mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

若出现问题：mysqld_safe The file /usr/local/mysql/bin/mysqld
does not exist or is not executable. Please cd to the mysql installation
directory and restart this script from there as follows:
./bin/mysqld_safe&（通常mysql未安装到/usr/local/mysql目录下）

解决方法：进入到mysql的安装目录，执行./bin/mysqld_safe &

 

进入mysql修改密码

mysql -uroot ;

update user set password=password('新密码') where user='root';

 

2.关闭mysqld_safe

cd /usr/local/mysql/bin

mysqladmin -uroot -p shutdown

 

3.linux下常用命令

 

启动mysql

mysqld --defaults-file=/etc/my.cnf

 

关闭mysql

mysqladmin -uroot -p shutdown

 

连接mysql

mysql -u用户名 -hIP  -p密码

 

查看当前登录用户

select user();

 

查看所有的库

show databases;

 

选择操作test库

use test;

 

查看当前登录的库

select database();

 

查看所有的表

show tables;