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