mysql笔记

1，在linux上安装和使用mysql

yum install -y mysql-server mysql mysql-devel

service mysqld start

chkconfig --list | grep mysqld

chkconfig mysqld on

chkconfig --list | grep mysqld

rpm -qa | grep mysql

/usr/bin/mysqladmin -u root password 'mysql'

mysql -u root -p

mysql -h主机地址 -u用户名 －p用户密码

-D, --database=name 
-h, --host=name
-p, --password[=name]
-P, --port=# 
-u, --user=name

CREATE DATABASE GITLABTEST;
SHOW DATABASES;
use gitlabtest;
select * from user;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;FLUSH PRIVILEGES;

2，错误集锦

>mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
mysql可以直接登录，mysql -u root -p 不用输入密码可以登录，客户端root也可以登录
mysql>select user,password,host from mysql.user;
root用户的localhost没有密码，root用户的hostname有密码
solution :
mysql -u root -h hostname -p
grant all privileges on *.* to 'root'@'localhost' identified by '123456';
flush privileges;
select user,password,host from mysql.user;
use mysql
UPDATE user SET Password=PASSWORD('mysql') WHERE user = 'root';
FLUSH PRIVILEGES;