创建MySQL用户和组
Java代码
sudo groupadd mysql
sudo useradd -r -g mysql mysql
view plaincopy to clipboardprint
sudo groupadd mysql
sudo useradd -r -g mysql mysql
Note:
-r option to create a user that does not have login permissions to your server host. Omit this option to permit logins for the user。
-g：指定用户所属的群组。
解压和移动到应用目录
Java代码
tar –zxvf mysql-5.1.56-linux-i686-glibc23.tar.gz
sudo mv mysql-5.1.56-linux-i686-glibc23 /usr/local/mysql51
建立软连接
为mysql51目录建立软连接mysql，以便快速访问mysql51目录。
Java代码
//相当于cd /usr/local/mysql51 和cd /usr/local/mysql等效
sudo ln -s /usr/local/mysql51 mysql
cd /usr/local/mysql
访问权限配置
Java代码
cd /usr/local/mysql
//注意后面有小数点
sudo chown -R mysql .
//将组属性改为mysql组。
sudo chgrp -R mysql .
创建MySQL授权表初始化
Java代码
sudo scripts/mysql_install_db --user=mysql
//将文件的所有属性改为root用户。
sudo chown -R root .
//将数据目录的所有属性改为mysql用户。
sudo chown -R mysql data
//下面这条给所有人弄data的权限，仅为了方便调试,不需要
sudo chmod a+rwx -R data
//下面的命令可选。copy配置文件到相关目录
sudo cp support-files/my-medium.cnf /etc/my.cnf
启动mysql
sudo bin/mysqld_safe --user=mysql &
//下面的命令可选。开机自启动mysql.server服务.
//To start mysqld at boot time you have to copy
//support-files/mysql.server to the right place for your system
sudo cp support-files/mysql.server /etc/init.d/mysql.server
service mysql.server start
//查看启动是否正常
./bin/mysqladmin version
sudo scripts/mysql_install_db --user=mysql
//将文件的所有属性改为root用户。
sudo chown -R root .
//将数据目录的所有属性改为mysql用户。
sudo chown -R mysql data
//下面这条给所有人弄data的权限，仅为了方便调试,不需要
sudo chmod a+rwx -R data
//下面的命令可选。copy配置文件到相关目录
sudo cp support-files/my-medium.cnf /etc/my.cnf
启动mysql
sudo bin/mysqld_safe --user=mysql &
//下面的命令可选。开机自启动mysql.server服务.
//To start mysqld at boot time you have to copy
//support-files/mysql.server to the right place for your system
sudo cp support-files/mysql.server /etc/init.d/mysql.server
service mysql.server start
//查看启动是否正常
./bin/mysqladmin version
sudo scripts/mysql_install_db --user=mysql
//将文件的所有属性改为root用户。
sudo chown -R root .
//将数据目录的所有属性改为mysql用户。
sudo chown -R mysql data
//下面这条给所有人弄data的权限，仅为了方便调试,不需要
sudo chmod a+rwx -R data
//下面的命令可选。copy配置文件到相关目录
sudo cp support-files/my-medium.cnf /etc/my.cnf
启动mysql
sudo bin/mysqld_safe --user=mysql &
//下面的命令可选。开机自启动mysql.server服务.
//To start mysqld at boot time you have to copy
//support-files/mysql.server to the right place for your system
sudo cp support-files/mysql.server /etc/init.d/mysql.server
service mysql.server start
//查看启动是否正常
./bin/mysqladmin version./bin/mysqladmin Ver 8.42 Distrib 5.1.56, for pc-linux-gnu on i686
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.1.56-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 12 min 41 sec