MySQL on Debian to install and set up – so it works
- Log in to Debian as the Administrator and open the Terminal.
- With "sudo apt-get install mysql-server" will be downloaded MySQL and the Installation will be started. Just follow the instructions.
- The Installation is complete, you must assign a password. You can use "mysqladmin -u root -p password "PASSWORD"" and change "PASSWORD" with a desired password.
- Now you can log in with "mysql-u root-p" and entering the previously set password in MySQL.
- With the command "create database if not exists database name;" create a new database with the name "database name", you can customize arbitrary.
- This database now has a user with the password "secret".
- create user 'www-data'@'localhost' identified by 'secret';
- grant usage on *.* to 'www-data'@'localhost' identified by 'secret';
Debian: MySQL setup
Further steps: install MySQL and set up
- Thus, the user receives the appropriate access, enter the following command:
- grant all privileges on database name.* to 'www-data'@'localhost';
- flush privileges;
- With "quit" or "exit" to exit the configuration. Then, use "sudo systemctl restart mysql.service", to start the MySQL Server and apply the Changes.
- With the command "create database if not exists database name;" create a new database with the name "database name", you can customize arbitrary.
- This database now has a user with the password "secret".
- create user 'www-data'@'localhost' identified by 'secret';
- grant usage on *.* to 'www-data'@'localhost' identified by 'secret';
You want to in addition, under Linux Debian a FTP Server set up, we will show you in the next practice tip on how to do this.
