Shulou(Shulou.com)06/01 Report--

The following content mainly brings you the analysis and solution of Cloud Virtual Machine remote connection mysql problem. The knowledge mentioned here is slightly different from books. It is summarized by professional technicians in the process of contacting users. It has certain experience sharing value and hopes to bring help to readers.

1. Solve the problem of remote connection under centos.

1. Check whether the firewall is closed under centos:

Pass process: ps -aux| grep firewalld

ps -ef |grep firewalld

By Service: pgrep firewalld

systemctl status firewalld

Close firewall: systemctl stop firewall

service iptables off

2. The remote connection takes the sshd service, which is the ssh protocol, and the port number is 22.

Check if SSHD service is enabled:

Pass process: ps -aux| grep sshd

By Service: pgrep sshd

Start service: systemctl start sshd

Add sshd service to boot: chkconfig sshd on

3. Check IP address.

ifconfig

In windows, cmd window inside, ping the ip address above, see if you can ping through.

What about the wrong report?

The database is disconnected? The following questions arise?

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ？？？

What should I do?

The requested URL/etc/rc.d/init.d/mysqld/was not found on this server.

If it is a permission problem, change the permissions first #chown -R mysql:mysql /var/lib/mysql

[root@localhost ~]# /etc/init.d/mysqld start

Start MySQL: [OK]

[root@localhost ~]# mysql -uroot -p

10038？(Remote not authorized)

10060？(Join the Safety Team)

Related tutorials: mysql video tutorial

II. Database operation:

1. Open MySQL.

systemctl start mariadb

2. First, set the password, and you will be prompted to enter the password first.

mysql_secure_installation

3. Create ordinary users:

create user zhangsan@localhost identified by 'root';

mysql -u root -p

update user set host='%' where host='127.0.0.1';

flush privileges;

4. Authorize root user to log in remotely:

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

flush privileges;

update user set user='root' where host='localhost';

Related tutorials: mysql video tutorial

Third, mysql remote connection is not the solution:

1. Firewall:

Set firewall, boot does not start:

chkconfig firewalld off

Close the firewall:

systemctl disable firewalld

systemctl stop firewalld

Or kill the firewall process.

See if firewall processes exist: pgrep firewalld,

Then kill the process: kill pid

or pkill firewalld.

2. No remote permissions

Grant remote login privileges

grant all privileges on *.* to 'root'@'%' identified by '123456';

flush privileges;

3. Start sshd service: systemctl starts sshd

Add sshd service to boot: chkconfig sshd on

4. Access projects under Linux in windows

Open Apache service in Linux, namely httpd service systemctl start httpd or: service httpd start

Windows Browsers below access projects under Linux: Enter IP address in the browser address bar: (you can check your IP address through ifconfig) For example, 192.168.0.1

V. Virtual domain name configuration method under Windows:

Configure the local hosts file.

Location: C:\Windows\System32\drivers\etc\hosts

Add the corresponding virtual host name.

192.168.226.129 linux.cc

CRUD of mysql;

Add:

INSERT INTO `user` (`id`, `username`, `passwd`, `sex`) VALUES ('1', 'zhangsan', '12345', '')

Update:

UPDATE `user` SET `sex`='female ' WHERE (`id`='2')

Delete:

DELETE FROM `user` WHERE (`id`='2')

Inquiry:

SELECT * FROM `user`;

VI. Virtual host

ServerAdmin webmaster@dummy-host.example.com

DocumentRoot /www/docs/dummy-host.example.com

ServerName dummy-host.example.com

ErrorLog logs/dummy-host.example.com-error_log

CustomLog logs/dummy-host.example.com-access_log common

VII. Set startup: switch to command line mode by default graphical interface

Change to command mode multi-user.target:

[root@localhost ~]# systemctl set-default multi-user.target

rm '/etc/systemd/system/default.target'

ln -s '/usr/lib/systemd/system/multi-user.target' '/etc/systemd/system/default.target'

[root@localhost ~]# systemctl get-default

Get: multi-user.target: achieve effect.

Switch to: graphical mode: systemctl set-default graphical.target

VIII. Description of configuration file

A: httpd.conf Apache's main configuration file.

B: php.ini PHP main configuration file

D: httpd-vhost.conf File to change when configuring virtual hosts

E: my.cnf mysql main configuration file under linux

Note: my.ini is the main configuration file of mysql under Windows

Related tutorials: PHP video tutorial

The above is the server remote connection mysql when the problem appears comprehensive details, more please pay attention to other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.