MYSQL RPM包的安装

MySQL-5.5.22-1.linux2.6.i386.tar
解压开
tar -xvf MySQL-5.5.22-1.linux2.6.i386.tar------就是解压的过程
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
有这些文件

MySQL-client-5.5.22-1.linux2.6.i386.rpm
MySQL-devel-5.5.22-1.linux2.6.i386.rpm
MySQL-embedded-5.5.22-1.linux2.6.i386.rpm
MySQL-server-5.5.22-1.linux2.6.i386.rpm
MySQL-shared-5.5.22-1.linux2.6.i386.rpm
MySQL-test-5.5.22-1.linux2.6.i386.rpm


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
开始安装MYSQL
[root@localhost home]# rpm -ivh MySQL-server-5.5.22-1.linux2.6.i386.rpm
Preparing...                ########################################### [100%]

[root@localhost home]# rpm -ivh MySQL-client-5.5.22-1.linux2.6.i386.rpm
Preparing...                ########################################### [100%]

都安装好了
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
启动--[root@localhost home]# service mysql start

停止--[root@localhost home]# service mysql stop

重新启动----[root@localhost home]# service mysql restart
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
创建mysql的password

mysql在安装的时候是自己创建了一个mysql的用户

[root@localhost home]# passwd mysql
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
修改root的密码
安装完成的时候mysql的root密码是空的需要修改

[root@localhost home]# su -l mysql
-bash-3.2$ mysqladmin -u root password 'zhang546'
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
开始访问
-bash-3.2$ mysql -u root -p
Enter password:
登陆成功
mysql>
查看数据库
mysql>show databases;

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
远程访问mysql的话需要设置
A.改表法。可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改成"%"

1	$ mysql -u root -ppassword

2	mysql> use mysql;

3	mysql>update user set host = '%' where user = 'root' ;

4	mysql>select host, user from user;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

B.授权法。例如，你想myuser使用mypassword从任何主机连接到mysql服务器的话。

GRANT ALL PRIVILEGES ON *.* TO 'myuser' @ '%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器，并使用mypassword作为密码 

GRANT ALL PRIVILEGES ON *.* TO 'myuser' @ '192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION ;

我用的第一个方法,刚开始发现不行,在网上查了一下,少执行一个语句

1	mysql>FLUSH PRIVILEGES

使修改生效，就可以了

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

C.在安装mysql的机器上运行：

1	$mysql -h localhost -u root

2	//这样应该可以进入MySQL服务器

3	mysql> GRANT ALL PRIVILEGES ON *.* TO 'root' @ '%' WITH GRANT OPTION

4	//赋予任何主机访问数据的权限

5	mysql>FLUSH PRIVILEGES

6

//修改生效

7	mysql>EXIT

8	//退出MySQL服务器

这样就可以在其它任何的主机上以root身份登录啦。

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

用Navicat for MySQL访问

如果提示：Can't get hostname for your address，除了2中授权外还需要如下设置：
编辑/etc/my.cnf，在：[mysqld]内添加一行：

1	skip-name-resolve

MySQL忽略数据库表名大小写
修改/etc/my.cnf，在[mysqld]内添加一行： 

1	lower_case_table_names= 1

如果没有/etc/my.cnf文件，在/usr/share/mysql目录下根据自己需要找一下my-*.cnf文件，复制为/etc/my.cnf 

1	$cp /usr/share/mysql/my-medium.cnf /etc/my.cnf

　　到此，MySQL就安装完成了， 再补充一点，如果要在外部访问，记得在Linux的防火墙设置中添加3306端口。