Mysql+linux安裝
建議在Linux中使用RPM包來安裝MySQL
本次採用二進位制安裝(版本為5.7)
To install and use a MySQL binary distribution, the command
sequence looks like this:
shell> groupadd mysql
shell> useradd -r -g mysql mysql --useradd -g mysql mysql
shell> cd /usr/local
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> mkdir mysql-files
shell> chmod 770 mysql-files
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> bin/mysql_install_db --user=mysql # Before MySQL 5.7.6
shell> bin/mysqld --initialize --user=mysql # MySQL 5.7.6 and up
shell> bin/mysql_ssl_rsa_setup # MySQL 5.7.6 and up
shell> chown -R root .
shell> chown -R mysql data mysql-files
shell> bin/mysqld_safe --user=mysql & --啟動mysql伺服器
[root@dgryxrdb mysql]# bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data
2015-04-17T02:42:12.943581Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-04-17T02:42:13.359873Z 0 [Warning] InnoDB: New log files created, LSN=45790
2015-04-17T02:42:13.418680Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2015-04-17T02:42:13.481356Z 0 [Warning] Failed to setup SSL
2015-04-17T02:42:13.481394Z 0 [Warning] SSL error: SSL context is not usable without certificate and private key
2015-04-17T02:42:13.497882Z 1 [Warning] A temporary password is generated for root@localhost: -bb84ecF*!d4
[root@dgryxrdb mysql]# bin/mysql_ssl_rsa_setup
OpenSSL 1.0.1e-fips 11 Feb 2013
Generating a 2048 bit RSA private key
..................................................+++
.........+++
writing new private key to 'ca-key.pem'
-----
writing RSA key
Signature ok
subject=/CN=MySQL_Server_5.7.7-rc_Auto_Generated_CA_Certificate
Getting Private key
Generating a 2048 bit RSA private key
...........................................................................................+++
........+++
writing new private key to 'server-key.pem'
-----
writing RSA key
Signature ok
subject=/CN=MySQL_Server_5.7.7-rc_Auto_Generated_Server_Certificate
Getting CA Private Key
Generating a 2048 bit RSA private key
....................+++
..................................................+++
writing new private key to 'client-key.pem'
-----
writing RSA key
Signature ok
subject=/CN=MySQL_Server_5.7.7-rc_Auto_Generated_Server_Certificate
Getting CA Private Key
server-cert.pem: OK
client-cert.pem: OK
Generating RSA private key, 2048 bit long modulus
........................................+++
..................................................................................................+++
e is 65537 (0x10001)
writing RSA key
[root@dgryxrdb mysql]# mysqld_safe --user=mysql &
[1] 19371
[root@dgryxrdb mysql]# 150417 14:00:53 mysqld_safe Logging to '/usr/local/mysql/data/dgryxrdb.localdomain.err'.
150417 14:00:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
安裝完畢後可以修改使用者許可權,否則無法登入 以 --skip-grant-tables登入,修改密碼
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28258625/viewspace-1651159/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- codis安裝 (java 安裝 + zookeeper 安裝 + go 安裝 + codis 安裝JavaGo
- 安裝npm 解除安裝npm 安裝apidocNPMAPI
- mysql安裝 (yum 安裝)MySql
- MMM安裝、MHA安裝
- mysql安裝------RPM包安裝及解除安裝MySql
- oracle安裝:OUI安裝Oracle(圖形介面安裝)OracleUI
- ffmpeg安裝之mac安裝Mac
- docker安裝及解除安裝Docker
- 02 安裝git、安裝TortoiseGitGit
- Ubuntu解除安裝和安裝Ubuntu
- Orace RAC安裝-DNS安裝DNS
- caffe安裝系列——安裝OpenCVOpenCV
- SPARK 安裝之scala 安裝Spark
- mac 安裝opencv homebrew安裝MacOpenCV
- Oracle 安裝與解除安裝Oracle
- solaris mysql 安裝 解除安裝MySql
- BiocManager安裝,devtools安裝dev
- 安裝HomeBrew提示已安裝並無法解除安裝
- SQL Server 2012 安裝——安裝 OR 解除安裝SQLServer
- win10安裝版怎麼安裝_安裝版win10安裝教程Win10
- mysql安裝-----二進位制包安裝及解除安裝MySql
- cocoapods安裝/解除安裝/使用
- Mac Redis安裝與解除安裝MacRedis
- [ 安裝 ] Zeppelin安裝步驟!
- Ubuntu安裝和解除安裝mongodbUbuntuMongoDB
- linux 安裝yum 安裝phpLinuxPHP
- [雲原生]Docker - 安裝&解除安裝Docker
- JDK的安裝與解除安裝JDK
- selenium 安裝與 chromedriver安裝Chrome
- ORACLE TEXT安裝與解除安裝Oracle
- Centos 安裝yum,安裝ansibleCentOS
- zabbix安裝—–nginx安裝和配置Nginx
- LAMP原始碼安裝+wordpress安裝LAMP原始碼
- mysql非安裝包安裝教程MySql
- kratos安裝及依賴安裝
- Linux安裝解除安裝MySQLLinuxMySql
- MySQL 5.7 原始碼安裝、Yum倉庫安裝、RPM安裝、二進位制安裝MySql原始碼
- window下安裝並使用nvm(含解除安裝node、解除安裝nvm、全域性安裝npm)NPM