[[email protected] /]# rpm -qi mysql-server
Name : mysql-server Relocations: (not relocatable)
Version : 5.1.73 Vendor: CentOS
Release : 3.el6_5 Build Date: Thu 13 Feb 2014 03:42:39 AM CST
Install Date: Thu 12 Mar 2015 02:50:14 PM CST Build Host: c6b9.bsys.dev.centos.org
Group : Applications/Databases Source RPM: mysql-5.1.73-3.el6_5.src.rpm
Size : 25882723 License: GPLv2 with exceptions
Signature : RSA/SHA1, Thu 13 Feb 2014 03:48:08 AM CST, Key ID 0946fca2c105b9de
Packager : CentOS BuildSystem <http://bugs.centos.org>
URL : http://www.mysql.com
Summary : The MySQL server and related files
Description :
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. This package contains
the MySQL server and some accompanying files and directories.
[[email protected] /]#
我們在安裝完MySQL資料庫以後，會發現會多出一個mysqld的服務，這個就是咱們的資料庫服務，我們通過輸入 service mysqld start 指令就可以啟動我們的MySQL服務。
注意：如果我們是第一次啟動MySQL服務，MySQL伺服器首先會進行初始化的配置，如：
1
[[email protected] /]# service mysqld start
Initializing MySQL database: Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE 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 iZ23jffs85aZ password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
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 mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/bin/mysqlbug script!
[ OK ]
Starting mysqld: [ OK ]
[[email protected] /]#
[[email protected] /]# mysqladmin -u root password 'root'
[[email protected] /]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql>
四、mysql資料庫的主要配置檔案
/etc/my.cnf 這是mysql的主配置檔案
我們可以檢視一下這個檔案的一些資訊：
1
[[email protected] /]# cd /etc
[[email protected] etc]# ls my.cnf
my.cnf
[[email protected] etc]# cat my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[[email protected] etc]#
/var/lib/mysql mysql資料庫的資料庫檔案存放位置
我們的mysql資料庫的資料庫檔案通常是存放在了/ver/lib/mysql這個目錄下
1
[[email protected] /]# cd /var/lib/mysql
[[email protected] mysql]# ls -l
total 20488
-rw-rw---- 1 mysql mysql 10485760 Mar 12 14:58 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Mar 12 14:58 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Mar 12 14:57 ib_logfile1
drwx------ 2 mysql mysql 4096 Mar 12 14:57 mysql // 這兩個是mysql資料庫安裝時預設的兩個資料庫檔案
srwxrwxrwx 1 mysql mysql 0 Mar 12 14:58 mysql.sock
drwx------ 2 mysql mysql 4096 Mar 12 14:57 test // 這兩個是mysql資料庫安裝時預設的兩個資料庫檔案
[[email protected] mysql]#
我們可以自己建立一個資料庫，來驗證一下該資料庫檔案的存放位置
1
[[email protected] mysql]# cd /
[[email protected] /]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
//建立新的資料庫xiaobaobao
mysql> create database xiaobaobao;
Query OK, 1 row affected (0.00 sec)
mysql> quit
Bye
[[email protected] /]# cd /var/lib/mysql/
[[email protected] mysql]# ls -l
total 20492
-rw-rw---- 1 mysql mysql 10485760 Mar 12 14:58 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Mar 12 14:58 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Mar 12 14:57 ib_logfile1
drwx------ 2 mysql mysql 4096 Mar 12 14:57 mysql
srwxrwxrwx 1 mysql mysql 0 Mar 12 14:58 mysql.sock
drwx------ 2 mysql mysql 4096 Mar 12 14:57 test
drwx------ 2 mysql mysql 4096 Mar 12 15:14 xiaobaobao // 這個就是我們剛自己建立的xiaobaobao資料庫
[[email protected] mysql]#
[[email protected] log]# netstat -anp | more
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address
......
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 7459/mysqld
......
