mysql.sock
这个文件是负责mysql的连接的,如果该文件不存在,则无法访问mysql了. 规划
端口:62306
安装基本目录:/usr/local/webserver/mysql 数据库目录:/data0/mysql/data狼之家
二进制日志目录:/data0/mysql/binlog
延迟日志目录:mkdir -p /data0/mysql/relaylog
启动文件:/data0/mysql/mysqld
1、安装需要的编译软件及库文件
yum install cmake make -y
yum install gcc gcc-c++ autoconf bison automake zlib* flex* libxml* ncurses-devel libtool-ltdl-devel* -y
2、增加mysql用户及用户组,创建目录并将所有者更改为mysql groupadd mysql
useradd mysql -M -g mysql -s /sbin/nologin
mkdir -p /usr/local/webserver/mysql
mkdir -p /data0/mysql/data
mkdir -p /data0/mysql/binlog
mkdir -p /data0/mysql/relaylog
chown -R mysql:mysql /usr/local/webserver/mysql/
chown -R mysql:mysql /data0/mysql/
3、编译安装
mkdir -p /usr/local/src
cd /usr/local/src
wget sql/Downloads/MySQL-5.5/mysql-5.5.
tar -zxvf mysql-5.5.
cd mysql-5.5.28日本生命公司破产
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/webserver/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=complex -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=yes -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/data0/mysql/data -DMYSQL_TCP_PORT=62306
注:ENABLED_LOCAL_INFILE
cnf是否开启客户端本地存储以减轻数据库的负载
make
make install
4、创建myf配置文件
vi /data0/mysql/myf
5、初始化mysql
/usr/local/webserver/mysql/scripts/mysql_install_db --basedir=/usr/local/webserver/mysql --datadir=/data0/mysql/data --user=mysql
6、创建启动文件,并启动mysql
vi /data0/mysql/mysqld友商网在线会计
chmod +x /data0/mysql/mysqld
/data0/mysql/mysqld start|stop|restart|kill
7、用户管理
设置root密码
/usr/local/webserver/mysql/bin/mysqladmin -u root password '123456'
删除空密码、匿名的用户、
mysql> delete from mysql.user where password='';
mysql> delete from mysql.user where user='';
vsmmysql> flush privileges;
创建数据库管理帐户,允许远程用户访问。并将root更名为其他名称。wb193
CREATE USER 'leon'@'%' IDENTIFIED BY '123456';
GRANT ALL ON *.* TO 'leon'@'%' WITH GRANT OPTION;
RENAME USER 'root'@'localhost' TO 'leon'@'localhost';
flush privileges;
8、安全
(1)除了管理员帐号外,不要把file, process, super,reload,shutdown,grant权限授予管理员以外的账号
update mysql.user set file_priv = 'N' Where User=user_name and host =
host_name
update mysql.user set process_priv = 'N' Where User=user_name and host =
host_name
update mysql.user set super_priv = 'N'Where User=user_name and host =
host_name
update mysql.user set reload_priv = 'N' Where User=user_name and host =
host_name
update mysql.user set shutdown_priv = 'N' Where User=user_name and host =
host_name
update mysql.use
r set grant_priv = 'N' Where User=user_name and host =
host_name
(2)在配置文件myf中mysqld中括号下加入
local_infile = OFF #关闭读取文件
secure_auth = ON #开启更为安全的加密机制
show variables like '%secure_auth%';