CentOS使用yum安裝mysql
查看CentOS自带mysql是否已安裝:yum list installed | grep mysql若有自带安装的mysql,如何卸载CentOS系统自带mysql資料庫?mysql-libs.x86_64 5.1.73-5.el6_6@anaconda-CentOS-201508042137.x86_64/6.7yum -y remove mysql-libs.x86_64,若有多個依賴文件则依次卸載。
查看yum庫上的mysql版本信息:yum list | grep mysql 或 yum -y list mysql*
使用yum安装mysql資料庫:yum -y install mysql-server mysql mysql-devel注:安装mysql只是安装了資料庫,只有安装mysql-server才相當于安装了server及client。
假如輸入 mysql出現 error:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 表示未啟動 mysqld所以輸入service mysqld start,啟動後馬上出現以下訊息,提醒你的一些有用的訊息: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 video.yocoolnet.com 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
查看刚安装mysql数据库版本信息:rpm -qi mysql-server
設定 /etc/my.cnf
datadir=/var/lib/mysql
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
default-character-set = utf8
user=mysql
basedir=/var/lib
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default-character-set = utf8
設定 MySQL 服務隨系統一起啟動
# chkconfig mysqld on
確認 MySQL 自動啟動有打開
# chkconfig --list mysqld
如果2--5為on的狀態就OK
mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off
啟動 MySQL 服務
# service mysqld start 或 /usr/bin/mysqld_safe &確認 MySQL 是否已啟動#service mysqld statusmysqld (pid33778) is running...或cd /usr/mysql-test ; perl mysql-test-run.pl
啟動 MySQL 以後,必須設定 root 的密碼
# mysqladmin -u root password 'Your Password' 或者執行指令# /usr/bin/mysql_secure_installation試 root 是否可成功登入 mysql:mysql -u root -pEnter password: (輸入root 密碼)升級 MySQL database至最新# mysql_upgrade -u root -p輸入密碼
[重新安裝mysql]參考http://tecadmin.net/remove-mysql-completely-from-linux-system/註:以yum安裝在CentOS 5.11/i386 啟動時出現錯誤,see /var/log/mysqld.log :160414 10:07:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql160414 10:07:57 /usr/libexec/mysqld (mysqld 5.5.49) starting as process 9426 ...160414 10:07:57 Plugin 'FEDERATED' is disabled./usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist160414 10:07:57 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.160414 10:07:57 InnoDB: The InnoDB memory heap is disabled160414 10:07:57 InnoDB: Mutexes and rw_locks use InnoDB's own implementation160414 10:07:57 InnoDB: Compressed tables use zlib 1.2.3160414 10:07:57 InnoDB: Using Linux native AIO160414 10:07:57 InnoDB: Initializing buffer pool, size = 128.0M160414 10:07:57 InnoDB: Completed initialization of buffer pool160414 10:07:57 InnoDB: highest supported file format is Barracuda.160414 10:07:57InnoDB: Waiting for the background threads to start160414 10:07:58 InnoDB: 5.5.49 started; log sequence number 1595675160414 10:07:58 InnoDB: !!! innodb_force_recovery is set to 1 !!!160414 10:07:58 Server hostname (bind-address): '0.0.0.0'; port: 3306160414 10:07:58 - '0.0.0.0' resolves to '0.0.0.0';160414 10:07:58 Server socket created on IP: '0.0.0.0'.160414 10:07:58 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist原因是:啟動mysqld時無法自動建立 /var/lib/mysql/所有資料庫,因此需手動建立所有DB
mysql_install_db --user=mysql --ldata=/var/lib/mysql/===>check /var/lib/mysql/內已建立許多DB
升級成最新版:https://www.cadch.com/modules/news/article.php?storyid=227
頁:
[1]