How to install mysql5.7.* under ubuntu14.04 64-bit
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!
