mysql在linux下的安装_Mysql在linux下的安装

在这里使用的是MySQL二进制分发版

[root@Enterprise ~]# groupadd mysql

[root@Enterprise ~]# useradd -g mysql mysql

[root@Enterprise ~]# ls

mysql-6.0.0-alpha-linux-i686-glibc23.tar.gz

[root@Enterprise ~]# cd /usr/local

[root@Enterprise local]# gunzip < /root/mysql-6.0.0-alpha-linux-i686-glibc23.tar.gz | tar xvf -

建立软链接

[root@Enterprise local]# ln -s /usr/local/mysql-6.0.0-alpha-linux-i686-glibc23 mysql

[root@Enterprise local]# cd mysql

改变目录的属组和所有者

[root@Enterprise mysql]# chown -R mysql .

[root@Enterprise mysql]# chgrp -R mysql .

创造MySQL授权表

[root@Enterprise mysql]# scripts/mysql_install_db --user=mysql

Installing MySQL system tables...

[root@Enterprise mysql]# chown -R root .

[root@Enterprise mysql]# chown -R mysql data

测试启动mysql

[root@Enterprise mysql]# bin/mysqld_safe --user==mysql &

Starting mysqld daemon with databases from /var/lib/mysql

关闭

[root@Enterprise mysql]# bin/mysqladmin shutdown

STOPPING server from pid file /var/lib/mysql/mysqld.log

070727 07:50:25  mysqld ended

MySQL默认的数据文件存储目录为/var/lib/mysql，如果启动失败，需要改配置文件

[root@Enterprise mysql]# cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

或者直接修改/etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old_passwords=1

[mysql.server]

user=mysql

basedir=/var/lib/mysql

[mysqld_safe]

err-log=/var/log/mysqld.log

pid-file=/var/lib/mysql/mysqld.log

[client]

socket=/var/lib/mysql/mysql.sock

进入mysql

[root@Enterprise support-files]# mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 5 to server version: 6.0.0-alpha

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| test               |

| test_db            |

+--------------------+

4 rows in set (0.04 sec)

mysql> quit

执行脚本

mysql> source /home/mysql/test.sql

Query OK, 0 rows affected (0.03 sec)

先写这么多，以后再补充。