The selection of a client for Developing in a database is difficult. For MySQL, some of the Clients with surface and / or as a web-based solution available, but all have their quirks. Since I’m in the meantime a lot in the Shell, I came across. mycli is a Shell-based MySQL Client with some useful extensions in MySQL mitelieferten Shell.
At this point, I would like to present how you can install on the Raspberry Pi to the web server. I would like to Point out that the use of Apache2 as a web server on the Pi is very strong utilization.
To create a database, including all the rights for a new user is on the command line is relatively long, and accordingly, I can’t remember the commands, so in a nutshell, the necessary steps:
In this article I want to explain to you how to set up an Apache 2 Server with PHP. I’m going to add at the end of a “shell script”, so that you can automatically set up a web server.
Character sets, terrible. If you just want to make backups and to import and all the special characters are only cabbage and turnips.