Below are some useful commands to manage users in MySQL: Create Database The following command will create a new database Delete / Drop Database The following command will create a new database List Databases Run the following command to show a list of all databases
While I fully understand the security implications of running these legacy and unsupported versions of PHP and MySQL. I had an application that had these dependancies, but I wanted to move to a supported LTS version of Ubuntu. Once you have Ubuntu 18.04 installed with Apache 2, you can use…
Below are some useful commands to manage users in MySQL: List all Users Run the following query to get a list of the users: Add User To create a new account: Here the ‘adm’ user is created, which can only connect from localhost. In MySQL a user is always associated…