[root@linux-a ~]# rpm -ivh /media/Server/perl-DBI-1.52-1.fc6.i386.rpm
warning: /media/Server/perl-DBI-1.52-1.fc6.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
1:perl-DBI ########################################### [100%]
[root@linux-a ~]#
[root@linux-a ~]# rpm -ivh /media/Server/perl-DBD-MySQL-3.0007-1.fc6.i386.rpm
warning: /media/Server/perl-DBD-MySQL-3.0007-1.fc6.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
1:perl-DBD-MySQL ########################################### [100%]
[root@linux-a ~]#
[root@linux-a ~]# rpm -ivh /media/Server/mysql-5.0.22-2.1.i386.rpm
warning: /media/Server/mysql-5.0.22-2.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
1:mysql ########################################### [100%]
[root@linux-a ~]#
[root@linux-a ~]# rpm -ivh /media/Server/mysql-server-5.0.22-2.1.i386.rpm
warning: /media/Server/mysql-server-5.0.22-2.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
1:mysql-server ########################################### [100%]
[root@linux-a ~]#
[root@linux-a ~]# mysql_install_db
Installing all prepared tables
Fill help tablesTo start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h linux-a.test.com password 'new-password'
See the manual for more instructions.You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-testsPlease report any problems with the /usr/bin/mysqlbug script!The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[root@linux-a ~]#
[root@linux-a ~]# ls -l /var/lib/mysql/
总计 8
drwx------ 2 root root 4096 08-16 16:55 mysql
drwx------ 2 root root 4096 08-16 16:55 test
[root@linux-a ~]# chown -R mysql /var/lib/mysql/
[root@linux-a ~]# chgrp -R mysql /var/lib/mysql/
[root@linux-a ~]# service mysqld start
启动 MySQL: [确定]
[root@linux-a ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.22Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql>
[root@linux-a ~]# mysqladmin -u root password 111111 //将root用户的密码修改为111111
/var/lib/mysql/
/usr/share/mysql (mysql.server命令及配置文件)
/usr/bin (mysqladmin mysqldump等命令)
/etc/rc.d/init.d/ (启动脚本文件mysql的目录)
[root@linux-a ~]# chkconfig --list |grep mysql
mysqld 0:关闭 1:关闭 2:关闭 3:关闭 4:关闭 5:关闭 6:关闭
[root@linux-a ~]# chkconfig --add mysql
[root@linux-a ~]# chkconfig --del mysql
cd /home
mkdir data
[root@linux-a ~]# mysqladmin -u root -p shutdown
Enter password:
[root@linux-a ~]#
mv /var/lib/mysql /home/data/
[root@linux-a ~]# cp /usr/share/doc/mysql-server-5.0.22/my-medium.cnf /etc/my.cnf
vi my.cnf (用vi工具编辑my.cnf文件,找到下列数据修改之)
# The MySQL server
[mysqld]
port = 3306
#socket = /var/lib/mysql/mysql.sock(原内容,为了更稳妥用“#”注释此行)
socket = /home/data/mysql/mysql.sock (加上此行)
[root@test1 etc]# vi /etc/rc.d/init.d/mysql
#datadir=/var/lib/mysql (注释此行)
datadir=/home/data/mysql (加上此行)
MySQL的常用操作
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> use mysql;
Database changed
mysql> show tables;
mysql> create databases aaa;
create table 表名 (字段设定列表);
例如:在刚创建的aaa库中建立表name,表中有id(序号,自动增长),xm(姓名),xb(性别),csny(出身年月)四个字段
use aaa;
mysql> create table name (id int(3) auto_increment not null primary key, xm char(8),xb char(2),csny date);
可以用describe命令察看刚建立的表结构。
mysql> describe name;
+-------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+----------------+
| id | int(3) | | PRI | NULL | auto_increment |
| xm | char(8) | YES | | NULL | |
| xb | char(2) | YES | | NULL | |
| csny | date | YES | | NULL | |
+-------+---------+------+-----+---------+----------------+
mysql> insert into name values('','张三','男','1971-10-01');
mysql> insert into name values('','白云','女','1972-05-20');
可用select命令来验证结果。
mysql> select * from name;
+----+------+------+------------+
| id | xm | xb | csny |
+----+------+------+------------+
| 1 | 张三 | 男 | 1971-10-01 |
| 2 | 白云 | 女 | 1972-05-20 |
+----+------+------+------------+
mysql> update name set csny='1971-01-10' where xm='张三';
mysql> delete from name where xm='张三';
drop table 表名;
增加MySQL用户
mysql> grant select,insert,update,delete on *.* to user_1@"% " Identified by "123";
用新增的用户如果登录不了MySQL,在登录时用如下命令:
mysql -u user_1 -p -h 192.168.113.50 (-h后跟的是要登录主机的ip地址)
这里特别提示(使用mysql front链接时)
---开一个可以在远程任意妄为的用户:
grant all privileges on *.* to user_name@'%' identified by 'passwd '
grant all privileges on *.* to user_name@'localhost ' identified by 'passwd '