Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Linux5 install MySQL 5.6 (RPM mode)     - Ubuntu 14.04 install AMD graphics driver is fully dual monitor solution (Linux)

- Android float ball and boot from the start (Programming)

- Linux NFS FTP use (Server)

- To convert into a binary search tree sorted doubly linked list (Programming)

- ARM assembler instruction debugging method (Programming)

- Linux Quick Install MongoDB (Database)

- Node.js simple interface server (Server)

- Upgrade Goldengate 11.1.1.1.2 to 11.2.1.0.1 (Database)

- Mahout source code analysis: FP-Growth algorithm parallelization (Programming)

- MySQL to manage multiple instances of method (Database)

- A script to make your Ubuntu 14.04 Memory screen brightness (Linux)

- Nginx server security configuration (Server)

- Ora-14450: attempt to access ah transactional temptable already in use (Database)

- Create a DLL using MinGW and Attention (Programming)

- Linux Getting Started tutorial: How to backup Linux systems (Linux)

- Use $ BASH ENV variable to mention the right way under Linux (Linux)

- Swift string common method (Programming)

- Distributed transaction management Spring declarative transactions (Programming)

- C # using the HttpClient Note: Preheat the long connection (Programming)

- CentOS 6.6 permanent method to modify the DNS address (Linux)

 
         
  Linux5 install MySQL 5.6 (RPM mode)
     
  Add Date : 2018-11-21      
         
       
         
  MySQL is widely used in many fields, especially a lot of Internet companies, such as Tencent, Ali, and so on. In this paper, under Linux 5 is installed by rpm way Mysql, this is a relatively simple installation, the specific detailed below.
1. Prepare installation file
Download page: http: //dev.mysql.com/downloads/mysql/
Locate the file version and the corresponding required for download, if download is tar file, use tar decompression
I am in the Oracle Edelivery download, so as V44331-01.zip
# Installation environment
[Root @ linux1 Mysql_src] # cat / etc / issue
Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
Kernel \ r on an \ m
# Source file path
[Root @ linux1 Mysql_src] # pwd
/ Mysql_src
[Root @ linux1 Mysql_src] # unzip V44331-01.zip
Archive: V44331-01.zip
 extracting: MySQL-embedded-advanced-5.6.17-1.rhel5.i386.rpm
 extracting: MySQL-test-advanced-5.6.17-1.rhel5.i386.rpm
 extracting: MySQL-shared-advanced-5.6.17-1.rhel5.i386.rpm # MySQL shared libraries
 extracting: MySQL-devel-advanced-5.6.17-1.rhel5.i386.rpm # MySQL libraries and header files
 extracting: MySQL-client-advanced-5.6.17-1.rhel5.i386.rpm # MySQL client programs
 extracting: MySQL-server-advanced-5.6.17-1.rhel5.i386.rpm # MySQL server program
 extracting: MySQL-shared-compat-advanced-5.6.17-1.rhel5.i386.rpm # RHEL compatible package
 extracting: README.txt

 

2, MySQL default installation path
 Directory Contents of Directory
/ Usr / bin Client programs and scripts
/ Usr / sbin The mysqld server
/ Var / lib / mysql Log files, databases
/ Usr / share / info Manual in Info format
/ Usr / share / man Unix manual pages
/ Usr / include / mysql Include (header) files
/ Usr / lib / mysql Libraries
/ Usr / share / mysql Miscellaneous support files, including error messages,
                        character set files, sample configuration files, SQL for database installation
/ Usr / share / sql-bench Benchmarks

 

3, the installation MySQL
[Root @ linux1 Mysql_src] # rpm -ivh MySQL-server-advanced-5.6.17-1.rhel5.i386.rpm
Preparing ... ########################################### [100% ]
  1: MySQL-server-advanced ########################################### [100%]
2014-04-15 17:26:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-04-15 17:26:59 6524 [Note] InnoDB: Using mutexes to ref count buffer pool pages
                  ...........................
2014-04-15 17:27:06 6558 [Note] InnoDB: FTS optimize thread exiting.
2014-04-15 17:27:06 6558 [Note] InnoDB: Starting shutdown ...
2014-04-15 17:27:08 6558 [Note] InnoDB: Shutdown completed; log sequence number 1625987

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER!
You will find that password in '/root/.mysql_secret'.

You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.

Also, the account for the anonymous user has been removed.

In addition, you can run:

  / Usr / bin / mysql_secure_installation

which will also give you the option of removing the test database.
This is strongly recommended for production servers.

                  ...... ....... Snip
New default config file was created as /usr/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings

[Root @ linux1 Mysql_src] # rpm -ivh MySQL-client-advanced-5.6.17-1.rhel5.i386.rpm
Preparing ... ########################################### [100% ]
  1: MySQL-client-advanced ########################################### [100%]

[Root @ linux1 Mysql_src] # rpm -ivh MySQL-devel-advanced-5.6.17-1.rhel5.i386.rpm
Preparing ... ########################################### [100% ]
  1: MySQL-devel-advanced ########################################### [100%]
4, initialize MySQL and password
[Root @ linux1 Mysql_src] # service mysql start
Starting MySQL .. [OK]
[Root @ linux1 Mysql_src] # more /root/.mysql_secret
# The random password set for the root user at Tue Apr 15 17:27:05 2014 (local time): lyHfNb87EBXhJDe2

[Root @ linux1 Mysql_src] # mysql -u root -p
Enter password:
Welcome to the MySQL monitor Commands end with;. Or \ g.
Your MySQL connection id is 2
Server version: 5.6.17-enterprise-commercial-advanced

mysql> set PASSWORD = PASSWORD ( 'mysql');
Query OK, 0 rows affected (0.01 sec)

mysql> show databases;
+ -------------------- +
| Database |
+ -------------------- +
| Information_schema |
| Mysql |
| Performance_schema |
| Test |
+ -------------------- +
4 rows in set (0.03 sec)

 

5 to allow remote login
mysql> use mysql;
Database changed
mysql> select host, user, password from user;
+ ------------------- + ------ + ---------------------- --------------------- +
| Host | user | password |
+ ------------------- + ------ + ---------------------- --------------------- +
| Localhost | root | * E74858DB86EBA20BC33D0AECAE8A8108C56B17FA |
| Linux1.orasrv.com | root | * AE207AEF7D22B37183E435AAE64CECF7102A2DB2 |
| 127.0.0.1 | root | * AE207AEF7D22B37183E435AAE64CECF7102A2DB2 |
| :: 1 | root | * AE207AEF7D22B37183E435AAE64CECF7102A2DB2 |
+ ------------------- + ------ + ---------------------- --------------------- +
4 rows in set (0.02 sec)

mysql> update user set password = password ( 'mysql') where user = 'root';
mysql> update user set host = '%' where user = 'root' and host = 'localhost';
mysql> flush privileges;
mysql> exit

6, configure boot from the start
[Root @ linux1 Mysql_src] # chkconfig --list mysql
mysql 0: off 1: off 2: on 3: on 4: on 5: on 6: off
If not, use chkconfig mysql on set from the start
     
         
       
         
  More:      
 
- Security experience: to see how the experts deal with DDoS attacks (Linux)
- State and Linux nf_conntrack TCP disconnect time (Programming)
- ADSL router to defend their own network security methods (Linux)
- Java and Python use make way dictionary word search script (Programming)
- 8 Git tips (Linux)
- Win7 + Ubuntu Kylin + CentOS 6.5 installed three systems (Linux)
- MySQL 5.7 can not log in problem (Database)
- apt-get and apt-cache show command examples (Linux)
- Install the free open source financial software GnuCash 2.6.6 under Ubuntu (Linux)
- Installation Elementary OS Freya 20 things to do (Linux)
- Linux (SUSE) mount NTFS mobile hard practice (Linux)
- Spring use Cache (Programming)
- How to achieve the MySQL Oracle table associated with the two operations update (Database)
- Linux linux system security (Linux)
- How screenshots from the Linux command line (Linux)
- ethtool command Detailed (Linux)
- Fedora 22 installation and configuration optimization (Linux)
- Linux Bash share tips for getting started (Linux)
- sed command (Linux)
- Java precision four operations (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.