yum安装mysql
1、修改配置文件vi /etc/my.cnf
2、创建目录
mkdir -p /home/mysql_3306
3、更改权限
chown mysql:mysql -R /home/mysql_3306
4、yum安装(yum安装为系统自带,只适用于测试或非高性能需求)
yum install mysql
常用命令
查看连接:mysqladmin pr
查看有哪些库:mysqlshow
查看参数:mysqladmin var|grep dir
查看库:show databases;
查看用户:select user,host from mysql.user;
查看权限:show grants for root@’localhost’;
G授权:RANT ALL PRIVILEGES ON . TO ‘app_user’@’localhost’ identified by app_user;
my.conf示例
#my.cnf
[client]
#host = 127.0.0.1
default-character-set=utf8
[mysql]
prompt="hostname [\\d] [\\R:\\m:\\s]> "
pager="less -i -n -S"
no-auto-rehash
[mysqldump]
quick
max_allowed_packet = 32M
[mysqld]
user = mysql #用户
basedir = /usr/ #软件目录
datadir = /home/mysql_3306 #数据目录
port = 3306 #端口
socket = /home/mysql_3306/mysql.sock #套接字文件(进程间通信)
pid-file = /home/mysql_3306/mysql.pid #pid文件
max_allowed_packet = 32M #允许最大包32M
ft_min_word_len = 4 #全文索引的最小单词长度工。这个选项的默认设置是4,意思是在创建全文索引时不考虑那些由3个或更少的字符构建单词。
event_scheduler = 1 #事件调度器(1开启,0关闭)
character-set-server = utf8 #字符集
#performance #
net_read_timeout = 60 #
open_files_limit = 65535 #打