源码安装mysql-5.5.53.tar.gz
操作系统：CentOSrelease 6.8 (Final)
专注于为中小企业提供网站设计、成都网站制作服务,电脑端+手机端+微信端的三站合一,更高效的管理,为中小企业桐庐免费做网站提供优质的服务。我们立足成都，凝聚了一批互联网行业人才，有力地推动了1000+企业的稳健成长，帮助中小企业通过网站建设实现规模扩充和转变。
虚拟机：VMware
数据库：MySQL-5.5.53.tar.gz
注意事项：源码安装包mysql-5.5.32.tar.gz之后的版本安装方式发生了变化。
安装步骤如下：
#rpm -qa|grep mysql
#yum remove mysql*
#yum install cmake ncurses.x86_64 ncurses-devel.x86_64 bison-devel
#groupadd mysql
#useradd -g mysql mysql -s nologin
#mkdir -p application
#cd /application
application# mkdir mysql/data -p
#chmod -R 777 /mysql/data
#chmod -R 777 /mysql/data -p
#chmod -R 777 /mysql/data -f
#chown -R mysql:mysql /mysql
#chown -R mysql:mysql /mysql/data
#mkdir /var/lib/mysql
#chown -R mysql:mysql /var/lib/mysql
#rz #从终端上传到服务器
#tar xf mysql-5.5.53.tar.gz
[root@localhost mysql-5.5.53]#
cmake \
-DCMAKE_INSTALL_PREFIX=/application/mysql \
-DMYSQL_DATADIR=/application/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
[root@localhost mysql-5.5.53]#make && make install
[root@localhost support-files]# cp my-small.cnf /etc/my.cnf
[root@sky9890 scripts]# ./mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
WARNING: The host '*****' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
181025 7:57:40 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
181025 7:57:40 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.62) starting as process 18880 ...
OK
Filling help tables...
181025 7:57:41 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
181025 7:57:41 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.62) starting as process 18887 ...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h ****** password 'new-password'
Alternatively you can run:
/usr/local/mysql/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /usr/local/mysql/mysql-test ; perl mysql-test-run.pl
Please report any problems at http://bugs.mysql.com/
配置mysql的环境变量:
#vim /etc/profile.d/mysql.sh
#export PATH=/usr/local/mysql/bin:$PATH
#source /etc/profile.d/mysql.sh 立即生效
启动MySQL
添加服务，拷贝服务脚本到init.d目录，并设置开机启动
#cp support-files/mysql.server /etc/init.d/mysqld
#chkconfig mysqld on
#chkconfig mysqld --level 2345 on
#service mysqld start
配置root用户
MySQL启动成功后，root默认没有密码，我们需要设置root密码
#mysql
mysql> SET PASSWORD = PASSWORD('*****');
实战技术：
[root@sky9890 ~]# mysql
-bash: mysql: command not found
[root@sky9890 ~]# ln -s /usr/local/mysql/bin/mysql /usr/bin
[root@sky9890 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@sky9890 ~]# mysql -V
mysql Ver 14.14 Distrib 5.5.62, for Linux (x86_64) using EditLine wrapper
网站题目：源码安装mysql-5.5.53.tar.gz
链接URL：http://shouzuofang.com/article/jighjg.html