成都创新互联网站制作重庆分公司

LINUX下配置MYSQL

初次学习在Linux下配置MySQL，首先查找版本，环境；部署后，启动Mysql，检验数据库是否运行正常

成都创新互联公司坚持“要么做到，要么别承诺”的工作理念，服务领域包括：做网站、成都网站制作、企业官网、英文网站、手机端网站、网站推广等服务，满足客户于互联网时代的肥西网站设计、移动媒体设计的需求，帮助企业找到有效的互联网解决方案。努力成为您成熟可靠的网络建设合作伙伴！

[@more@]--查看LINUX版本
[root@sd ~]# cat /etc/issue
Red Hat Enterprise Linux AS release 4 (Nahant)
Kernel r on an m
[root@sd ~]# cat /proc/version
Linux version 2.6.9-5.ELsmp (bhcompile@decompose.build.redhat.com) (gcc version 3.4.3 20041212 (Red Hat 3.4.3-9.EL4)) #1 SMP Wed Jan 5 19:30:39 EST 2005
--Kernel
[root@sd ~]# uname -r
2.6.9-5.ELsmp
--查看CPU
[root@sd ~]# grep "model name" /proc/cpuinfo
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
--MEM
[root@sd ~]# free
total used free shared buffers cached
Mem: 4147280 1467312 2679968 0 105028 1141932
-/+ buffers/cache: 220352 3926928
Swap: 4192924 0 4192924
--信息
[root@sd ~]# cat /proc/cpuinfo
-------------------------
---检查linux软件管理包
[root@sd ~]# rpm -qa system-config-packages
system-config-packages-1.2.23-1
--显示mysql安装包
[root@sd ~]# rpm -q mysql
mysql-4.1.7-4.RHEL4.1
[root@sd ~]# rpm -q apache
package apache is not installed
[root@sd ~]# rpm -q php
php-4.3.9-3.1
[root@sd ~]# rpm -q perl
perl-5.8.5-12
--列出安装包的详细列表
[root@sd ~]# rpm -qa |grep php
php-gd-4.3.9-3.1
php-pear-4.3.9-3.1
php-xmlrpc-4.3.9-3.1
php-ldap-4.3.9-3.1
php-pgsql-4.3.9-3.1
php-devel-4.3.9-3.1
php-mbstring-4.3.9-3.1
php-domxml-4.3.9-3.1
php-ncurses-4.3.9-3.1
php-odbc-4.3.9-3.1
php-snmp-4.3.9-3.1
php-4.3.9-3.1
php-imap-4.3.9-3.1
[root@sd ~]# rpm -qa |grep mysql
mysql-devel-4.1.7-4.RHEL4.1
mysql-4.1.7-4.RHEL4.1
mysqlclient10-devel-3.23.58-4.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
freeradius-mysql-1.0.1-2.RHEL4
libdbi-dbd-mysql-0.6.5-10.RHEL4.1
[root@sd ~]# rpm -qa |grep apache
[root@sd ~]# rpm -ql mysql-4.1.7-4.RHEL4.1
/etc/ld.so.conf.d/mysql-i386.conf
/etc/init.d/mysqld
/etc/my.cnf
/usr/bin/msql2mysql
/usr/bin/mysql
/usr/bin/mysql_config
/usr/bin/mysql_find_rows
/usr/bin/mysql_tableinfo
/usr/bin/mysql_waitpid
/usr/bin/mysqlaccess
/usr/bin/mysqladmin
/usr/bin/mysqlbinlog
/usr/bin/mysqlcheck
/usr/bin/mysqldump
/usr/bin/mysqldumpslow
/usr/bin/mysqlimport
/usr/bin/mysqlsho
/usr/share/info/mysql.info.gz
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysqlaccess.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqlshow.1.gz
/usr/share/mysql
-------------------------------------------------------------
--Starting mysqld daemon with databases from /etc/init.d/mysqld
[root@sd mysql]# /etc/init.d/mysqld
Usage: /etc/init.d/mysqld {start|stop|status|condrestart|restart}
[root@sd mysql]# /etc/init.d/mysqld start
[root@sd mysql]# /etc/init.d/mysqld status
mysqld (pid 18373) is running...
[root@sd mysql]# netstat -nat
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:22273 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:32770 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
[root@sd mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 4 to server version: 4.1.7
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql>
察看mysql是否在自动启动列表中
/sbin/chkconfig --list
[root@sd opt]# mysqladmin -u -p shutdown
mysqladmin: shutdown failed; error: 'Access denied; you need the SHUTDOWN privilege for this operation'
[root@sd opt]# /etc/init.d/mysqld stop
Stopping MySQL: [ OK ]
Stopping MySQL: [ OK ]
[root@sd opt]# ls /var/lib/mysql
ibdata1 ib_logfile0 ib_logfile1 mysql test
[root@sd opt]# mv /var/lib/mysql /opt/mydata/
[root@sd opt]# ls /var/lib/ -alt
[root@sd opt]# ls /opt/mydata/mysql
ibdata1 ib_logfile0 ib_logfile1 mysql test
[root@sd opt]# cd /opt/mydata/mysql
[root@sd mysql]# ls
ibdata1 ib_logfile0 ib_logfile1 mysql test
[root@sd mysql]# cd mysql
[root@sd mysql]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@sd mysql]# /etc/init.d/mysqld status
mysqld (pid 18776) is running...
[root@sd mysql]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@sd mysql]# /etc/init.d/mysqld stop
Stopping MySQL: [ OK ]
[root@sd mysql]# ps -ef |grep mysql
root 18845 17994 0 16:27 pts/1 00:00:00 grep mysql
[root@sd mysql]# vi /etc/init.d/mysqld
#!/bin/bash
#
# mysqld This shell script takes care of starting and stopping
# the MySQL subsystem (mysqld).
#
# chkconfig: - 64 36
# description: MySQL database server.
# processname: mysqld
# config: /etc/my.cnf
# pidfile: /var/run/mysqld/mysqld.pid
# Source function library.
. /etc/rc.d/init.d/functions
# Source networking configuration.
. /etc/sysconfig/network

prog="MySQL"
datadir="/var/lib/mysql"
#datadir="/opt/mydata/mysql"
Entering Ex mode. Type "visual" to go to Normal mode.
:wq
"/etc/rc.d/init.d/mysqld" 111L, 2497C written
[root@sd mysql]# vi /etc/my.cnf
[mysqld]
#datadir=/opt/mydata/mysql
datadir=/var/lib/mysql
#socket=/opt/mydata/mysql/mysql.sock
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
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Entering Ex mode. Type "visual" to go to Normal mode.
:q
[root@sd mysql]# cd /opt/mydata
[root@sd mydata]# ls
mysql
[root@sd mydata]# mv mysql /var/lib/
[root@sd mydata]# ls /var/lib/mysql
ibdata1 ib_logfile0 ib_logfile1 mysql test
[root@sd mydata]# /etc/init.d/mysqld status
mysqld is stopped
[root@sd mydata]# /etc/init.d/mysqld start
Starting MySQL: [ OK ]
[root@sd mydata]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 3 to server version: 4.1.7
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> h
For the complete MySQL Manualonline, visit:
http://www.mysql.com/documentation
For info on technical support from MySQL developers, visit:
http://www.mysql.com/support
For info on MySQL books, utilities, consultants, etc., visit:
http://www.mysql.com/portal
List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (?) Synonym for `help'.
clear (c) Clear command.
connect (r) Reconnect to the server. Optional arguments are db and host.
delimiter (d) Set query delimiter.
edit (e) Edit command with $EDITOR.
ego (G) Send command to mysql server, display result vertically.
exit (q) Exit mysql. Same as quit.
go (g) Send command to mysql server.
help (h) Display this help.
nopager (n) Disable pager, print to stdout.
notee (t) Don't write into outfile.
pager (P) Set PAGER [to_pager]. Print the query results via PAGER.
print (p) Print current command.
prompt (R) Change your mysql prompt.
quit (q) Quit mysql.
rehash (#) Rebuild completion hash.
source (.) Execute a SQL script file. Takes a file name as an argument.
status (s) Get status information from the server.
system (!) Execute a system shell command.
tee (T) Set outfile [to_outfile]. Append everything into given outfile.
use (u) Use another database. Takes database name as argument.
For server side help, type 'help contents'
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.00 sec)
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
15 rows in set (0.00 sec)
mysql> describe db;
+-----------------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+---------------+------+-----+---------+-------+
| Host | char(60) | | PRI | | |
| Db | char(64) | | PRI | | |
| User | char(16) | | PRI | | |
| Select_priv | enum('N','Y') | | | N | |
| Insert_priv | enum('N','Y') | | | N | |
| Update_priv | enum('N','Y') | | | N | |
| Delete_priv | enum('N','Y') | | | N | |
| Create_priv | enum('N','Y') | | | N | |
| Drop_priv | enum('N','Y') | | | N | |
| Grant_priv | enum('N','Y') | | | N | |
| References_priv | enum('N','Y') | | | N | |
| Index_priv | enum('N','Y') | | | N | |
| Alter_priv | enum('N','Y') | | | N | |
| Create_tmp_table_priv | enum('N','Y') | | | N | |
| Lock_tables_priv | enum('N','Y') | | | N | |
+-----------------------+---------------+------+-----+---------+-------+
15 rows in set (0.00 sec)
mysql> select * from db;
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv |
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| % | test | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y |
| % | test_% | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y |
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
2 rows in set (0.00 sec)
mysql> create database sdtest;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| sdtest |
| test |
+----------+
3 rows in set (0.00 sec)
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
15 rows in set (0.00 sec)
mysql> use sdtest
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> create table name( id int(3) auto_increment not null primary key,csny date,xm char(9),xy char(9));
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
+------------------+
| Tables_in_sdtest |
+------------------+
| name |
+------------------+
1 row in set (0.00 sec)
mysql> select * from name;
Empty set (0.00 sec)
mysql> describe name ;
+-------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+----------------+
| id | int(3) | | PRI | NULL | auto_increment |
| csny | date | YES | | NULL | |
| xm | char(9) | YES | | NULL | |
| xy | char(9) | YES | | NULL | |
+-------+---------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> insert into name values('','1981-01-10','MM','SEXY');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> select * from name;
+----+------------+------+------+
| id | csny | xm | xy |
+----+------------+------+------+
| 1 | 1981-01-10 | MM | SEXY |
+----+------------+------+------+
1 row in set (0.00 sec)
[root@sd mydata]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 4 to server version: 4.1.7
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> use sdtest;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> insert into name values('','1981-03-30','GG','HANDSOME');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> insert into name values('','1981-03-30','DY','SMITH');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> select * from name;
+----+------------+------+----------+
| id | csny | xm | xy |
+----+------------+------+----------+
| 1 | 1981-01-10 | MM | SEXY |
| 2 | 1981-03-30 | GG | HANDSOME |
| 3 | 1981-03-30 | DY | SMITH |
+----+------------+------+----------+
3 rows in set (0.00 sec)
mysql> update name set xm='XX' where xm='DY';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from name;
+----+------------+------+----------+
| id | csny | xm | xy |
+----+------------+------+----------+
| 1 | 1981-01-10 | MM | SEXY |
| 2 | 1981-03-30 | GG | HANDSOME |
| 3 | 1981-03-30 | XX | SMITH |
+----+------------+------+----------+
3 rows in set (0.00 sec)
mysql> grant select ,insert,update,delete on *.* to hnzx_hq@"%" identified by "huangq";
Query OK, 0 rows affected (0.00 sec)
mysql> grant select ,update on sdtest.* to testman@localhost identified by "123";
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@sd mydata]# mysql -u hnzx_hq -p huangq
Enter password:
ERROR 1045 (28000): Access denied for user 'hnzx_hq'@'localhost' (using password: YES)
[root@sd mydata]# mysql -u hnzx_hq -p
Enter password:
ERROR 1045 (28000): Access denied for user 'hnzx_hq'@'localhost' (using password: YES)
[root@sd mydata]# mysql -u hnzx_hq -p -h
Enter password:
ERROR 1045 (28000): Access denied for user 'hnzx_hq'@'sd.server.gov.com' (using password: YES)
[root@sd mydata]# mysqldump -u root -p --opt sdtest >back_sdtest
Enter password:
[root@sd mydata]# ls /var/lib/mysql
ibdata1 ib_logfile0 ib_logfile1 mysql mysql.sock sdtest test
[root@sd mydata]# cd sdtest
-bash: cd: sdtest: No such file or directory
[root@sd mydata]# cd /var/lib/mysql/sdtest
[root@sd sdtest]# ls
db.opt name.frm name.MYD name.MYI
[root@sd sdtest]# mysqldump -u root -p --opt sdtest > back_sdtest
Enter password:
[root@sd sdtest]# ls /var/lib/mysql
ibdata1 ib_logfile0 ib_logfile1 mysql mysql.sock sdtest test
[root@sd sdtest]# cd /var/lib/mysql/sdtest
[root@sd sdtest]# ls
back_sdtest db.opt name.frm name.MYD name.MYI
[root@sd sdtest]# mysql -u root -p ccc < back_sdtest
Enter password:
ERROR 1049 (42000): Unknown database 'ccc'
[root@sd sdtest]# mysql -u root -p cc < back_sdtest
Enter password:
ERROR 1049 (42000): Unknown database 'cc'
[root@sd sdtest]#
网站名称：LINUX下配置MYSQL
链接分享：http://cxhlcq.com/article/jigcjg.html

其他资讯

全国免费咨询:

400-028-6601

业务咨询：028-86922220 / 13518219792

节假值班：18980820575 / 13518219792

联系地址：成都市太升南路288号锦天国际A幢1002号

Copyright © 成都创新互联科技有限公司重庆分公司 渝ICP备2021005571号
友情链接:： 成都网站建设 重庆网站建设 四川网站建设 重庆建设网站 移动服务器托管 成都服务器托管 云服务器 广告设计制作 重庆网页设计 重庆做网站 重庆网站制作 重庆网站建设 重庆网站公司 渝中网站制作 重庆网站设计

在线咨询

微信咨询

电话咨询

028-86922220（工作日）

18980820575（7×24）

提交需求

返回顶部