MYSQL安装后设置
在类UNIX系统中安装MYSQL后,必须初始化授权表、启动服务并确认服务工作正常,设置开机服务自启动,关机服务自关闭,对授权表分配密码给账户
在类UNIX系统中,授权表设置使用mysql_install_db程序,有一些安装方法已经自动运行该程序:
rpm 安装方式自动运行
原生包安装在Debian Linux, Ubuntu Linux, Gentoo Linux上,建议运行mysql_install_db(以上安装就是)
OS X 使用DMG版本自动运行mysql_install_db
其他平台的安装方式,包括二进制和源码安装,建议运行mysql_install_db
shell> cd BASEDIR 切换到安装目录
目录下有两个重要bin(需要配置路径)和scripts(mysql_install_db所在)
1:权限设置
如果是使用mysql用户安装不需要进行权限操作,如果是root用户安装进入mysql安装目录:
shell> chown -R mysql .
shell> chgrp -R mysql .
2:执行mysql_install_db
如果是root用户执行,必须加上--user参数
shell> scripts/mysql_install_db --user=mysql
如果需要改变目录:
shell> scripts/mysql_install_db --user=mysql \
--basedir=/opt/mysql/mysql \
--datadir=/opt/mysql/mysql/data
3:建议安装目录为root权限,data目录为mysql
shell> chown -R root .
shell> chown -R mysql data
4:如果使用插件的话SELECT ... INTO DUMPFILE 使用插件plugin_dir 或者在启动文件中使用--secure-file-priv
5:如果你想从 support-files 复制一份标准配置,需要复制到 /etc/my.cnf, or /etc/mysql/my.cnf 进行相关编辑,如果不进行复制,mysql会使用默认配置,如果想配置开机自启动,需要将you can copy support-files/mysql.server to the location where your system has its startup files
6:启动MYSQL 服务
shell> bin/mysqld_safe --user=mysql &
If the command fails immediately and prints mysqld ended, look for information in the error log (which by default is the host_name.err file in the data directory).
If you neglected to create the grant tables by running mysql_install_db before proceeding to this step, the following message appears in the error log file when you start the server:
mysqld: Can't find file: 'host.frm'
This error also occurs if you run mysql_install_db as root without the --user option. Remove the datadirectory and run mysql_install_db with the --user option as described previously.
7:使用mysqladmin确认mysql是否在运行
[root@mysql5 mysql5.6.22]# bin/mysqladmin version
8:关闭mysql服务
shell> bin/mysqladmin -u root shutdown
9:为了确定MYSQL服务能够再次启动,再次执行
shell> bin/mysqld_safe --user=mysql &
10:验证能够查询到服务信息
[root@mysql5 mysql5.6.22]# bin/mysqlshow
+--------------------+
| Databases |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
11:MYSQL 标准套件
sql-bench
you can use to compare how MySQL performs on different platforms.
-----------------------------------------------------------------------------
以上是官网建议make install后步骤,下面是我的步骤:
[root@mysql5 mysql5.6.22]# cd /u01/mysql5.6.22 切换到MYSQL安装目录
[root@mysql5 mysql5.6.22]# chown -R mysql .
[root@mysql5 mysql5.6.22]# chgrp -R mysql .
[root@mysql5 mysql5.6.22]# scripts/mysql_install_db --user=mysql
[root@mysql5 mysql5.6.22]# chown -R root .
[root@mysql5 mysql5.6.22]# chown -R mysql data
[root@mysql5 mysql5.6.22]# bin/mysqld_safe --user=mysql &
[1] 19332
[root@mysql5 mysql5.6.22]# 150126 06:09:58 mysqld_safe Logging to '/u01/mysql5.6.22/data/mysql5.6.err'.
150126 06:09:58 mysqld_safe Starting mysqld daemon with databases from /u01/mysql5.6.22/data
[root@mysql5 mysql5.6.22]# jobs
[1]+ Running bin/mysqld_safe --user=mysql &
[root@mysql5 mysql5.6.22]# ps -ef | grep mysqld 查看是否启动
root 19332 2357 0 06:09 pts/1 00:00:00 /bin/sh bin/mysqld_safe --user=mysql
mysql 19422 19332 0 06:09 pts/1 00:00:00 /u01/mysql5.6.22/bin/mysqld --basedir=/u01/mysql5.6.22 --datadir=/u01/mysql5.6.22/data --plugin-dir=/u01/mysql5.6.22/lib/plugin --user=mysql --log-error=/u01/mysql5.6.22/data/mysql5.6.err --pid-file=/u01/mysql5.6.22/data/mysql5.6.pid
root 19474 2357 0 06:17 pts/1 00:00:00 grep mysqld