This serves as my own notes – I always forget the syntax.
- How to deal with UNIX command line programs
Use MySQL command to login to running MySQL instance. If this is on local host you can try
mysql -uroot # no password
mysql -uroot -p # asks for password
Use -H option to connect to external MySQL host (on shared hosting).
Then create a new database using CREATE DATABASE command. Here we create a database called joomla.
mysql> create database joomla;Query OK, 1 row affected (0.00 sec)
And then we create a MySQL user whose access is limited to this database only. In this case we create admin user with admin password. Note that MySQL accepts local connections only by default, so MySQL or this user is not exposed to Internet (and potential attacks).
Username is joomla and password is joomladbpassword.
GRANT ALL ON joomla.* TO 'joomla'@'localhost' identified by 'joomladbpassword';
… and now you can proceed to install Joomla.