mysql笔记
来源:互联网 发布:shop域名注册 编辑:程序博客网 时间:2024/05/23 13:21
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;
- Mysql笔记
- MySQL笔记
- mysql笔记
- MySQL笔记
- mySql 笔记
- mysql笔记
- mysql笔记
- mysql笔记
- Mysql笔记
- MySQL笔记
- MySQL 笔记
- mysql笔记
- MySQL笔记
- MySQL 笔记
- mysql 笔记
- mysql笔记
- MySQL笔记
- mysql笔记
- spring有三种启动方式,使用ContextLoaderServlet,ContextLoaderListener和ContextLoaderPlugIn.
- 如何fix suspect mode in SQL Server
- Java StringBuffer和StringBuilder
- struts2 Action生命周期
- hdu 3746 Cyclic Nacklace
- mysql笔记
- vbdjsfhjkeafkehfguefrtikjaglksjdkghjdasglksdgsdgdsg
- 使用VS2012编译QT 5.2.1静态库
- nodejs
- 在mybatis sql mapper文件中使用枚举(ognl表达式)
- TOJ 1550 Fiber Communications -- 枚举 + 线段树
- EXIF格式定义
- DOI成功的例子
- target和currentTarget属性的区别