mysql学习笔记1

1 Mysql安装
rpm -ivh mysql-libs-5.1.73-3.el6_5.x86_64.rpm
rpm -ivh perl-DBD-MySQL-4.013-3.el6.x86_64.rpm
rpm -ivh mysql-5.1.73-3.el6_5.x86_64.rpm
rpm -ivh mysql-server-5.1.73-3.el6_5.x86_64.rpm
设置开机自启动
chkconfig mysqld on
启动
netstat -nlp
service mysqld start
配置外网3306端口可以访问
vim /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
配置外网访问数据库
mysql -uroot
use mysql
update user set host='%' where host='127.0.0.1' and user='root';
2 mysql配置
配置文件路径：/etc/my.cnf
配置文件样例：/usr/share/mysql下
ls *.cnf 可以根据实际需要将样例配置文件复制到/etc下改名为my.cnf重启mysql生效
2 sql基础
ddl:show databases;
create database test1;
drop database test1;


授出权限：grant select,insert on test.* to 'xiaolq'@'localhost' identified by '123';
收回权限：revoke select,insert on test.* from 'xiaolq'@'localhost';
3 帮助的使用
? contents
? Data Types
4 information_schema库存储元数据，都是视图；