MySql Virtual Machine and Xshell5 connection process, mysqlxshell5
We will introduce the basic configuration of the connection between the virtual machine and Xshell5.
1. Install the Virtual Machine. Follow the prompts to install it step by step. Pay attention to adding the image file and the virtual machine is complete.
2. Download an Xshell5 file. After installation, modify the NIC status of the virtual machine.
1). Edit ifcfg-eth0,
# Vi/etc/sysconfig/network-scripts/ifcfg-eth0
2) Click I, -- inner -- appears, modify ONBOOT = YES, Esc to exit editing, and the wq command to save and exit.
3). Enter
Service network restart;
4) enter the command ip address a on the VM to find the ip address (usually the first ip address of 2) and connect to Xshell5.
3.
Create a new file, enter the IP address, and click User Authentication. Click OK to connect.
4. Open Xshell5
1). service mysqld start; 2)./usr/local/mysql/bin/mysql-uroot-p enter mysql and enter the password
The second entry:
Open the VM and enter the user name and password.
Open Xshell
1). service mysqld start; 2)./usr/local/mysql/bin/mysql-uroot-p enter mysql and enter the password