Phpmysadmin works fine and I do see all the active databases.
However, I need to be able to use the command line, but I get the following error when trying to do so:
- Code: Select all
eric@eric-lunix32:~/Desktop$ mysql -u root
The program 'mysql' is currently not installed. You can install it by typing:
sudo apt-get install mysql-client-5.0
bash: mysql: command not found
So I did the "sudo apt-get install mysql-client-5.0" command to manually install. (Or I think I did it through synaptic?)
Then I started getting this error:
- Code: Select all
eric@eric-lunix32:/$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
So I went into Synaptic and uninstalled mysql-client.
Now I get this error:
- Code: Select all
eric@eric-lunix32:/$ mysql -u root
bash: /usr/bin/mysql: No such file or directory
So how do I access mysql through the command line?
Thanks