mysql使用笔记

mysql安装：
http://www.mamicode.com/info-detail-1790594.html
http://www.cnblogs.com/zczc1996/p/6270521.html


./bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql/  --datadir=/usr/local/mysql/data/


mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld


service mysqld stop






设置mysql密码:
set password = password('root');

或

set password for 'root'@'%' = password('newpass');
flush privileges;

以格式化输出结果：
select * from user\G;


修改可远程访问
select host, user from user;
直接修改模式：
update user set host = '%' where user = 'root' and host = 'localhost';
附加权限模式：
grant all privileges on *.* to root@'%' identified by '123456';
flush privileges;


设置开机自动启动
chkconfig --add mysqld
chkconfig mysqld on


设置path
vi /etc/profile
export PATH=/usr/local/mysql/bin:$PATH










问题：
mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
	mkdir -p /var/run/mysqld
	chown mysql:mysql /var/run/mysqld
客户端连接失败：
	ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
	ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

mariadb安装：	

[root@yl-web yl]# yum install mariadb-server mariadb 

mariadb数据库的相关命令是：
systemctl start mariadb  #启动MariaDB
systemctl stop mariadb  #停止MariaDB
systemctl restart mariadb  #重启MariaDB
systemctl enable mariadb  #设置开机启动
mysql -u root -p

mysql-5.6.33安装
http://www.cnblogs.com/bookwed/p/5896619.html