I know that some users may say that this is a duplication but seriously I have combed the answers and those on the internet for over half a day and I am so frustrated i am going to explode.
Now that therapeutic explanation is done, I have installed MySql Server and MariaDb 10 from the Ubuntu repositories on Ubuntu 12.04 LTS and input the root password when it is installing[When the pink screen appears and prompts for the root password] and the installation goes through as smoothly as a knife through butter.
Now the real frustration begins in either of the below 2 scenarios:
- When I enter the sudo /usr/bin/mysql_secure_installation command nd am prompted to enter the root password
or
2.When I enter the mysql -u root -p command and am prompted for the password.
Please I really need help on this - I have lost count of the number of times I have had to uninstall and reinstall either MySQL or MariaDb because this pain in neck erf an error.