s mysql>\g Since the mysql root password is now set,if you need touse mysql aain (as the mysql root).you will need to use: s mysql -u root-p and then the password at the prompt Backup-Settings configure a backup Altematively There is more than just one way to set the mysql roo password and create a database.For example mysgladmin can be used: s mysqladmin -u root -p password yourpassword and s mysgladmin -u root -p create databasel d isa command-line tool provided by the default LAMP install. Phpmyadmin and mysql-workbench All mysql tasks including setting the root password and creating databases can be done via a graphical 1.Lam using Ubuntu server (command line) 2.Iam using a desktop Use method to install phpmyadmin Troubleshooting Phpmyadmin&mysql-workbench If youget blowfish_Choose and set a phrase for cryptography in the file /etc/phpmyadmin/blowfish secret.ine.php and copy the line (not the php tags)into the file /ete/phpmyadmin/config inc.php or you will receive an error. If you get a 404 error upon visiting http://localhost/phpmvadmin:You will need to configure apache2.confto work with Phpmyadmin. s gksudo gedit /etc/apache2/apache2.conf Include the following line at the bottom of the file,save and quit. Include /etc/phpmyadmin/apache.conf Altemative:install phpMyAdmin from source$ mysql> \q Since the mysql root password is now set, if you need to use mysql again (as the mysql root), you will need to use: $ mysql -u root -p and then enter the password at the prompt. Backup-Settings Please, let's say something in which directories mysql stores the database information and how to configure a backup Alternatively There is more than just one way to set the mysql root password and create a database. For example mysqladmin can be used: $ mysqladmin -u root -p password yourpassword and $ mysqladmin -u root -p create database1 mysqladmin is a command-line tool provided by the default LAMP install. Phpmyadmin and mysql-workbench All mysql tasks including setting the root password and creating databases can be done via a graphical interface using phpmyadmin or mysql-workbench. To install one or both of them, first enable the universe repository 1. I am using Ubuntu server (command line) 2. I am using a desktop Use any method to install phpmyadmin Troubleshooting Phpmyadmin & mysql-workbench If you get blowfish_secret error: Choose and set a phrase for cryptography in the file /etc/phpmyadmin/blowfish_secret.inc.php and copy the line (not the php tags) into the file /etc/phpmyadmin/config.inc.php or you will receive an error. If you get a 404 error upon visiting http://localhost/phpmyadmin: You will need to configure apache2.conf to work with Phpmyadmin. $ gksudo gedit /etc/apache2/apache2.conf Include the following line at the bottom of the file, save and quit. $ Include /etc/phpmyadmin/apache.conf Alternative: install phpMyAdmin from source