To doso, start the server, thenissue the following commands:
/usr/local/mysql//bin/mysqladmin-u root password 'new-password'
/usr/local/mysql//bin/mysqladmin-u root -h node6.test.com password 'new-password'
Alternatively you can run:
/usr/local/mysql//bin/mysql_secure_installation
whichwill also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended forproduction servers.
See the manual formoreinstructions.
You can start the MySQL daemon with:
cd/usr/local/mysql/; /usr/local/mysql//bin/mysqld_safe&
You can testthe MySQL daemon with mysql-test-run.pl
cd/usr/local/mysql//mysql-test; perl mysql-test-run.pl
Please report any problems with the /usr/local/mysql//scripts/mysqlbugscript!
注，从上面的内容中我们看到了几个警告，我们查看一下。
140104 16:18:43 [Warning] '--default-character-set'is deprecated and will be removed ina future release. Please use '--character-set-server'instead.
140104 16:18:43 [Warning] '--skip-locking'is deprecated and will be removed ina future release. Please use '--skip-external-locking'instead.
OK
Filling help tables...
140104 16:18:43 [Warning] '--default-character-set'is deprecated and will be removed ina future release. Please use '--character-set-server'instead.
140104 16:18:43 [Warning] '--skip-locking'is deprecated and will be removed ina future release. Please use '--skip-external-locking'instead.
从上面的警告可以看到，--default-character-set、--skip-locking选项已经过时，建议使用--character-set-server、--skip-external-locking。
7.查看一下初始化目录
[root@node6 data]# ls /data/mysql/
mysql mysql-bin.000001 mysql-bin.000002 mysql-bin.index test
8.启动一下mysql
[root@node6 ~]# service mysqld start
Starting MySQL.. SUCCESS!
好了，到这里我们的mysql基本就安装完成，但我们还提做上些优化工作。
10.输出mysql的man手册至man命令的查找路径
123 [root@node6 ~]# yum install -y man
[root@node6 ~]# vim /etc/man.config
MANPATH /usr/local/mysql/man
11.输出mysql的头文件至系统头文件路径/usr/include
[root@node6 mysql]# ln -sv /usr/local/mysql/include /usr/include/mysql
12.输出mysql的库文件给系统库查找路径
[root@node6 mysql]# echo '/usr/local/mysql/lib'> /etc/ld.so.conf.d/mysql.conf
[root@node6 mysql]# ldconfig
13.修改PATH环境变量，让系统可以直接使用mysql的相关命令
[root@node6 mysql]# vim /etc/profile.d/mysql.sh
exportPATH=$PATH:/usr/local/mysql/bin/
[root@node6 mysql]# source /etc/profile
[root@node6 mysql]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection idis 2
Server version: 5.1.73-log Source distribution
Copyright (c) 2000, 2013, Oracle and/orits affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/orits
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;'or '\h'forhelp. Type '\c'to clearthe current input statement.
mysql>
好了，到这里我们的mysql就全部安装完成了，下面我们来准备一下测试环境。