For instance, I could use for my phpMyAdmin site residing on my Raspbian Stretch Lite. If you already own a domain, you may want to create a subdomain out of your existing domain. The next step is to designate a domain name for accessing your phpMyAdmin site. GRANT ALL ON *.* TO a domain name for your phpMyAdmin site Once you are inside the interactive shell, run the following commands to create a database user that have the privileges to administer any database in your MariaDB / MySQL server: Or the MySQL interactive shell with the following command: To do so, we first get into MariaDB interactive shell with the following command: Hence, we need to create a database user for us to login through phpMyAdmin. This authentication mode cannot be used for logging into phpMyAdmin for administering your database.
The Authentication Plugin allows the user to use operating system credentials when connecting to MariaDB via Unix socket. The root user of MariaDB / MySQL could be using the Authentication Plugin for authentication. Run the following command to install the mbstring extension for PHP 7.0 on Raspbian Stretch Lite:Ĭreating a database user for administering your database via phpMyAdmin Without the mbstring extension, phpMyAdmin is unable to split strings correctly and it may result in unexpected results. Ssh mbstring extension for PHP 7.0 on Raspbian Stretch Lite Suppose that your Raspbian Stretch Lite had gotten the IP address 192.168.1.109 from your home router and you had the pi user in the system, run the following command on your terminal to SSH into your Raspberry Stretch Lite: Using SSH to get into your Raspbian Stretch Lite If you had not done so, you may want to reference either the Raspberry Pi 3 WordPress tutorial or Raspberry Pi Zero W WordPress tutorial to setup your LEMP stack. This post assumes that you had setup a Raspberry Pi running a Raspbian Stretch Lite, Nginx, MariaDB / MySQL and PHP 7 LEMP stack. If you want to build your next project with a Raspbian Stretch Lite, Nginx, MariaDB / MySQL and PHP 7 LEMP stack, you may want to consider setting up phpMyAdmin as well. The phpMyAdmin project is a solid software tool written in PHP, that can help us handle the administration of MySQL / MariaDB over the web. How to setup phpMyAdmin on a Raspbian Stretch Lite, Nginx, MariaDB / MySQL and PHP 7 LEMP stack
0 kommentar(er)
