Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ RHEL 6.4 installed MySQL 5.6.27     - Android developers learning Adapter (data adapter) (Programming)

- Spark and Hadoop comparison (Server)

- Ubuntu 14.04 Enable root and disable the guest (Linux)

- Virtual Judge environment to build and configure under Ubuntu (Server)

- DRBD + Heartbeat solve NFS single point of failure (Server)

- C ++ 11 feature: decltype keywords (Programming)

- DRBD rapid installation and deployment (Server)

- Linux system security check method (Linux)

- Oracle 11g users to create, authorize and import dmp file (Database)

- Use Git in Eclipse (Linux)

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

- Linux Security trust with users (Linux)

- Struts2 dynamic call DMI and error Solution (Programming)

- Automated Password Generator: Linux under a special password generator (Linux)

- Under CentOS yum install Nginx smooth switch mounted to Tengine (Server)

- Spring3 + SpringMVC + Hibernate4 full annotation environment configuration (Server)

- Apache site default home page settings (Server)

- Tip: Use Cryptsetup U disk encryption (Linux)

- Linux kernel programming parameter passing between modules and function calls (Programming)

- Docker manage data (Linux)

 
         
  RHEL 6.4 installed MySQL 5.6.27
     
  Add Date : 2017-08-31      
         
         
         
  Download (temporary address, such as unavailable, please go to the official website to download Oracle)

. Using rpm install mysql server you want to install:

ftp://pepstack.com/pub/rpm/MySQL-server-5.6.27-1.el6.x86_64.rpm

To install the mysql client:

ftp://pepstack.com/pub/rpm/MySQL-client-5.6.27-1.el6.x86_64.rpm

ftp://pepstack.com/pub/rpm/MySQL-devel-5.6.27-1.el6.x86_64.rpm

Server installation process:

Delete the old:

# Rpm -qa | grep -i mysql

mysql-libs-5.1.66-2.el6_3.x86_64

# Rpm -ev --nodeps mysql-libs-5.1.66-2.el6_3.x86_64

Caution: You may need to delete the old file (if any):

# Rm -f /etc/my.cnf

# Rm -rf / usr / var / lib / mysql

Install the new version:

# Rpm -ivh ./MySQL-server-5.6.27-1.el6.x86_64.rpm

Client installation process:

# Rpm -ivh ./MySQL-client-5.6.27-1.el6.x86_64.rpm

# Rpm -ivh ./MySQL-devel-5.6.27-1.el6.x86_64.rpm

Server startup and logon:

# Service mysql start

# Mysql -u root

ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO)

Resolve this error:

1 Stop mysql service:

# Service mysql stop

2 Start mysql service, skip verification:

# Mysqld_safe --skip-grant-tables &

3 Login mysql:

# Mysql --user = root mysql

4 Set the root user password:

mysql> update user set Password = PASSWORD ( 'abcd1234');

mysql> flush privileges;

mysql> exit;

5 You can now kill the mysqld_safe process:

# Killall mysqld_safe &

6 to restart the mysql service:

# Service mysql start

View Port:

# Netstat -nat | grep 3306

Client login (ipaddr for the mysql service where the server ip address):

# Mysql -u root -h ipaddr -pabcd1234
     
         
         
         
  More:      
 
- An Example of GoldenGate Extract Process Hang Problem Solving (Database)
- Android custom ViewPager create kaleidoscopic image transition effects (Programming)
- XP virtual machine under VirtualBox solve occupy 100% CPU problem (Linux)
- Linux beginners should know 12 commands (Linux)
- systemd-nspawn Quick Guide (Linux)
- ActiveMQ5.10.2 version configuration JMX (Linux)
- Linux 101 hack book reading notes (Linux)
- Ora-00020: maximum number of processes (500) exceeded (Database)
- Intruder tools Knark Analysis and Prevention Linux environment (Linux)
- Linux operating system buffer overflow attacks Countermeasures (Linux)
- Ubuntu terminal command - see the port occupied and off (Linux)
- Python when automated operation and maintenance often used method (Programming)
- MongoDB relations, references, index query coverage (Database)
- ActiveMQ memory settings and flow control (Linux)
- jQuery update the content and method of use 3.0 (Programming)
- Zabbix monitors Nginx status (Server)
- MySQL combination Git achieve differential backups can be used in the production environment (Database)
- Oracle: RETURNING clause (Database)
- Nginx Module Development - get user ip (Server)
- Linux landing problem (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.