|
下载mysql：
http://downloads.mysql.com/archives.php
选择一个mysql的版本，之后一定要看好，下glibc的。如：mysql-5.0.90-linux-i686-glibc23.tar.gz
本例中下载到了/media目录下，这个不是好习惯...
▲安装mysql:
下面是linux命令
[plain] view plaincopy
- :$ sudo groupadd mysql
- :$ sudo useradd -g mysql mysql
- :$ cd /usr/local
- :$ tar zvxf /media/mysql-5.0.90-linux-i686-glibc23.tar.gz [plain] view plaincopy
- :$ mv mysql-5.0.90-linux-i686-glibc23 mysql [plain] view plaincopy
- :$ cd mysql
- :$ sudo chown -R mysql .
- :$ sudo chgrp -R mysql .
- :$ scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql
- :& cd ..
- :$ sudo chown -R root mysql .
- :$ cd mysql
- :$ sudo chown -R mysql data
- :$ bin/mysqld_safe --basedir=/usr/local/mysql --user=mysql &
至此，mysql安装成功。 因为在运行状态，我没有ctrl-c，只好再开一个ssh窗口... ▲为mysql的root用户添加密码 下面是linux命令 [c-sharp] view plaincopy
- cd /usr/local/mysql/bin ./mysql -u root
进入mysql后： [c-sharp] view plaincopy
- mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "chang";
其实是设置了root的localhost的密码为chang
显示执行成功，然后exit退出mysql。 之后，再次登录mysql，这次要用密码了： [c-sharp] view plaincopy
- cd /usr/local/mysql/bin./mysql -u root -p
输入密码chang之后，可以正常登录，如下： Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 1
Server version: 5.0.90 MySQL Community Server (GPL) Type 'help;' or '/h' for help. Type '/c' to clear the current input statement. 查看一下用户信息: [c-sharp] view plaincopy
- mysql> select user,host,password from mysql.user;
结果如下： +------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | localhost | *F05D019BA3BEC01CA9FBD4141E4EA57A28EF3EDF | ← (root密码为chang)
| root | linux | | ← (root密码为空)
| root | 127.0.0.1 | | ← (root密码为空)
| | localhost | |
+------+-----------+----------+ 分别更改它们的密码： [c-sharp] view plaincopy
- mysql> set password for root@localhost=password('chang');
[c-sharp] view plaincopy
- mysql> set password for root@linux=password('chang');
[c-sharp] view plaincopy
- mysql> set password for root@127.0.0.1=password('chang');
再次查看用户信息会发现已经更改过来。 然后退出mysql。 ▲把mysql做成服务 [c-sharp] view plaincopy
- sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
启动mysql服务 [c-sharp] view plaincopy
- sudo /etc/init.d/mysql start
这时候就可以重启机器试试了
重启后再登陆mysql，发现可以登陆。服务制作成功! ▲配置mysql [c-sharp] view plaincopy
- vi /etc/my.cnf
(注释：如果没有自动生成my.cnf文件，那么：安装完的mysql包下有个support-files文件夹，其中有my-huge.cnf等，将my-huge copy一份，改名为my.cnf,将其适当地修改（当然是根据你的数据库配置）然后copy至/etc/my.cnf) 打开my.cnf后 找到[client] 添加：
default-character-set = utf8 # 默认字符集为utf8 找到[mysqld] 添加:
default-character-set = utf8 #默认字符集为utf8
init_connect = 'SET NAMES utf8' #设定连接mysql数据库时使用utf8编码，以让mysql数据库为utf8运行 修改好后,重新启动即可.
我这里是重启了mysql的服务： [c-sharp] view plaincopy
- sudo /etc/init.d/mysql restart
(有一次找不到sock，这样重启两次服务之后居然可以了!!!汗。) 之后进入mysql，查一下是否更改了字符集:
[c-sharp] view plaincopy
- cd /usr/local/mysql/bin./mysql -u root -p
[c-sharp] view plaincopy
- mysql> show variables like 'character%';
出现下面的画面： +--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/ |