Here are some of my compilations using command line.
For those who are lost in linuxworld here is my simple guide.
1. If you already install MySQL, look at the processes in System/Administration/System Monitor to see if MySQL is running. If you are on the command line try
~$ : ps -aux | grep mysql
If it is running, you should be able to login from the console with this command
~$ : mysql -u username -p”
it will ask the password. It assumes the host name is localhost, i.e. the machine itself.
Other way around to be sure it is running
~$ : sudo /etc/init.d/mysql status
or
~$ : mysql -u root -p
If in case you forget or don’t remember your MySQL password this command will help you.
~$ :
sudo dpkg-reconfigure mysql-server-5.0
Advertisement
