yum install -y mysql-server mysql mysql-devel
service mysqld start
chkconfig --list | grep mysqld
chkconfig mysqld on
chkconfig --list | grep mysqld
/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 权限 on 数据库.* to 用户名@登录主机 identified by "密码"
grant select,insert,update,delete on *.* to user1@localhost Identified by "password1";
GRANT ALL PRIVILEGES on *.* TO gitlab@'localhost' IDENTIFIED BY 'gitlab'; FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'gitlab'@'%' IDENTIFIED BY 'gitlab' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
Access denied for use ''@''
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mysql');
UPDATE user SET Password=PASSWORD('mysql') WHERE user = 'root';
[root@localhost init.d]# 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;
host is not allowed to coonect to this Mysql server
update user set host = '%' where user = 'root'
root用户能在server端登录,但是在客户端登录时显示Access denied for use 'root'@'server'.
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'gitlab'@'%' IDENTIFIED BY 'gitlab' WITH GRANT OPTION;
FLUSH PRIVILEGES;
select user,host,password from mysql.user;
强行重新修改密码,方法如下:
/etc/init.d/mysql stop (service mysqld stop )
/usr/bin/mysqld_safe --skip-grant-tables &
[root@localhost ~]# mysql
mysql>use mysql
mysql>update user set password=password("123456") where user="root";
mysql>flush privileges;
mysql>exit
service mysqld start
chkconfig --list | grep mysqld
chkconfig mysqld on
chkconfig --list | grep mysqld
/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 权限 on 数据库.* to 用户名@登录主机 identified by "密码"
grant select,insert,update,delete on *.* to user1@localhost Identified by "password1";
GRANT ALL PRIVILEGES on *.* TO gitlab@'localhost' IDENTIFIED BY 'gitlab'; FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'gitlab'@'%' IDENTIFIED BY 'gitlab' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
Access denied for use ''@''
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mysql');
UPDATE user SET Password=PASSWORD('mysql') WHERE user = 'root';
[root@localhost init.d]# 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;
host is not allowed to coonect to this Mysql server
update user set host = '%' where user = 'root'
root用户能在server端登录,但是在客户端登录时显示Access denied for use 'root'@'server'.
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'gitlab'@'%' IDENTIFIED BY 'gitlab' WITH GRANT OPTION;
FLUSH PRIVILEGES;
select user,host,password from mysql.user;
强行重新修改密码,方法如下:
/etc/init.d/mysql stop (service mysqld stop )
/usr/bin/mysqld_safe --skip-grant-tables &
[root@localhost ~]# mysql
mysql>use mysql
mysql>update user set password=password("123456") where user="root";
mysql>flush privileges;
mysql>exit