debian下安装mysql
1.把安装包mysql-5.1.60.tar.gz下载到/usr/local目录下减压2.安装客户端与服务器apt-get install mysql-serverapt-get install mysql-client==============安全卸载mysql停止mysql服务，如果不管用，就grep包括"mysql“的进程，全部pkill掉；1：apt-get remove mysql-server --purge2：apt-get remove mysql-common --purge2：apt-get remove mysql-client --purge加--purge实现完全卸载。=========================================a、数据库目录/var/lib/mysql/b、配置文件/usr/share/mysql（mysql.server命令及配置文件）c、相关命令/usr/bin(mysqladmin mysqldump等命令)d、启动脚本=========================启动或者停止数据库cd /usr/local目录下service mysql start service mysql stop /mysqladmin -u root -p shutdown================================================把"/var/lib/mysql"数据库文件整个目录移到"/mysql_data"（我没用这么做）root@debian:/var/lib/mysql# mv /var/lib/mysql/ /opt/wksp/mysql_data/进入msyql命令行root@debian:/etc# mysql -u root -p删除空用户，强烈建议。mysql> delete from mysql.user where user='';Query OK, 0 rows affected (0.00 sec)刷新权限表，以便可以使更改立即生效。mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)创建数据库及查看mysql> create database mystudentDB;Query OK, 1 row affected (0.00 sec)mysql> use mystudentDB;Database changedmysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || mystudentDB |+--------------------+3 rows in set (0.01 sec)mysql> source /opt/wksp/CreatInsertStudent.sqlQuery OK, 0 rows affected, 1 warning (0.00 sec)Query OK, 0 rows affected (0.01 sec)Query OK, 1 row affected (0.00 sec)Query OK, 1 row affected (0.00 sec)Query OK, 1 row affected (0.00 sec)Query OK, 1 row affected (0.00 sec)Query OK, 1 row affected (0.01 sec)Query OK, 1 row affected (0.00 sec)mysql> SELECT * FROM student;+--------+--------+------+------+| id | name | sex | age |+--------+--------+------+------+| 201201 | 张三 | 男 | 21 || 201202 | 李四 | 男 | 22 || 201203 | 王五 | 女 | 20 || 201204 | 赵六 | 男 | 21 || 201205 | 小红 | 女 | 19 || 201206 | 小明 | 男 | 22 |+--------+--------+------+------+6 rows in set (0.00 sec)mysql> show tables;+-----------------------+| Tables_in_mystudentDB |+-----------------------+| student |+-----------------------+1 row in set (0.00 sec)mysql> drop database mystudentDB;Query OK, 1 row affected (0.00 sec)如果查询出来的数据是乱码的话:找到"my.ini"配置文件，最终发现my.ini里的2个character_set把client改成gbk，把server改成utf8就可以了。
