
PHP makes it possible to produce dynamic and interactive pages using your own scripts and popular web development frameworks. Grant all on webdata.* to 'username' identified by 'password' Change the password ( password): create database webdata Change the database name ( webdata) and username ( username). Next, you can create a database and grant your users permissions to use databases.Įnter MySQL’s root password when prompted.Ĭreate a database and grant your users permissions on it.

If you already have a secure root password, you do not need to change it. It is recommended that you select yes ( y) for all questions. Run mysql_secure_installation to remove the test database and any extraneous user permissions added during the initial installation process: sudo mysql_secure_installation Input a secure password when prompted by the installation. Install MySQL: sudo apt-get install mysql-server MySQL is a relational database management system (RDBMS) and is a popular component of many applications. Restart Apache: sudo systemctl restart apache2

Should you need to disable a site, you can use a2dissite.
