Raspberry Pi 3 Installation MySQL service

Demand

Install the MySQL service on the Raspberry Pi and turn on remote access

Steps to install MySQL server

$ sudo apt-get install Mysql-server

I thought the middle will let me prompt input database root password, did not think smooth sailing, direct completion, I am going crazy, the password is what. Search found, you can use the following command, blank password login

$ sudo mysql-u root

Set Root password

Use Mysql;update user set plugin= ' Mysql_native_password ' where user= ' root '; UPDATE user SET Password=password (' Your own password ') WHERE user= ' root '; flush privileges;exit;

Operation MySQL

$ sudo/etc/init.d/mysql Status/start/stop/restart

Turn on MySQL remote access

Modify the MySQL configuration to allow remote logins

$ sudo vim/etc/mysql/mariadb.conf.d/50-server.cnf# will bind-address this line out and then restart $ sudo/etc/init.d/mysql Restart

Set up your account to log in remotely

$ mysql-uroot-puse MySQL; GRANT all privileges on * * to ' root ' @ '% ' identified by ' root account password ' with GRANT option;flush privileges;

You can then use other clients to connect directly to the

Original address: Raspberry Pi 3 installation MySQL service
Tags: Raspberry Pi mysql

Smart recommendations

• Ubuntu AppArmor where sacred
• The first use of Raspberry Pi 3
• Raspberry Pi 3 Boot and system configuration
• Raspberry Pi 3 's audio configuration
• Raspberry Pi 3 to build your own voice weather alarm clock

Raspberry Pi 3 Installation MySQL service