Shulou(Shulou.com)05/31 Report--

Editor to share with you how to install mysql5.7.*, under ubuntu14.04 64-bit I believe that most people do not know much, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Go to the mysql website to download the mysql version of the corresponding operating system.

What I downloaded is (mysql-server_5.7.15-1ubuntu14.04_amd64.deb-bundle.tar)

And check out the steps for installing mysql in mysql reference Manual

The link is as follows

Http://dev.mysql.com/doc/refman/5.7/en/linux-installation-debian.html

Add: check whether the operating system version and process are 64-bit or 32-bit through uname-a

2. Install mysql (mainly for the content of the link above, in case mysql officially changes the link, so post the content)

Shell > tar-xvf mysql-server_MVER-DVER_CPU.deb-bundle.tar # replace here with mysql-server_5.7.15-1ubuntu14.04_amd64.deb-bundle.tar

Shell > sudo apt-get install libaio1

Shell > sudo dpkg-preconfigure mysql-community-server_*.deb

Sudo apt-get-f install

Shell > sudo dpkg-I mysql- {common,community-client,client,community-server,server} _ * .deb

3. Create a database

Here is an application database backed up from another mysql instance

Directly into the newly installed mysql instance.

Mysql > source / tmp/create_database.sql

4. Create a user

Mysql > CREATE USER 'zoe'@'%' IDENTIFIED BY' zoe'; # create a user zoe and allow access from the client

Mysql > grant all PRIVILEGES on db_zoe.* to zoe@'%';# gives zoe users all the permissions of database db_zoe

Mysql > flush privileges

5. Access the database db_zoe remotely through SQLyog client tools.

Problem encountered: the database can be accessed on the server, but not remotely.

Solution:

1). Whether ping IP_address is ping connected (confirm whether it is a firewall problem)

# the default mysql port is 3306, which can be viewed via netstat-an | grep 3306

2), telnet IP_address 3306 # enable telnet: "programs and Features"-> "Open or closed functions"-> Open telnet client in Control Panel

3) Open port 3306 in the firewall policy

# turn on the firewall

Shell > sudo iptables-An INPUT-p tcp-- dport 3306-j ACCEPT

4) modify the configuration file of mysql to allow other ip to access mysql

# Log out the parameter setting of bind_address. The file path is generally / etc/mysql/mysql.conf.d/mysqld.cnf

# bind_address=127.0.0.1

The above is all the contents of the article "how to install mysql5.7.* under ubuntu14.04 64-bit". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.