> groupadd mysql #创建mysql用户组
> useradd mysql -s /sbin/nologin -M -g mysql #创建mysql用户
3)下载解压
> wget https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.57.tar.gz
> tar -zxf mysql-5.5.57.tar.gz
4)cmake编译安装
> cd mysql-5.5.57> cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql55 -DMYSQL_DATADIR=/usr/local/mysql/data-DSYSCONFDIR=/etc/my.cnf -DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_MEMORY_STORAGE_ENGINE=1-DWITH_READLINE=1-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DMYSQL_TCP_PORT=3306-DENABLED_LOCAL_INFILE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DEXTRA_CHARSETS=all> make && make install
> vi /etc/my.cnf
#[mysqld] 下面添加: user=mysql
datadir=/data/mysql default-storage-engine=MyISAM
7)将mysql的启动服务添加到系统服务中
> cp support-files/mysql.server /etc/init.d/mysql
#现在可以使用下面的命令操作mysql
> service mysql start #启动mysql服务
> service mysql stop #停止mysql服务
> service mysql restart #重启mysql服务
8)看mysql是否成功
> netstat -tnl|grep 3306
9)开机启动
> chkconfig--addmysql
10)修改默认root账户密码,默认密码为空
#修改密码 cd 切换到mysql所在目录 > cd /usr/local/mysql > ./bin/mysqladmin -u root password #回车在接下来的提示中设置新密码即可。。 #最后重启mysql服务器> service mysql restart
11)简单优化
> select user,host from mysql.user;
> delete from mysql.user where user = '';
> delete from mysql.user where host = '::1';
> delete from mysql.user where host = 'localhost.localdomain';
> delete from mysql.user;
> grant all privileges on *.* to system@’localhost’ identified by ‘username’ with grant option;
> flush privileges;
> select user,host from mysql.user