need to login to mysql in unbuntu

Problems with the Linux version of XAMPP, questions, comments, and anything related.

need to login to mysql in unbuntu

Postby attaboy » 11. April 2012 23:33

I installed Xampp on unbuntu I can start lampp and it starts up apache, mysql and some ftp application. I can run some mysql commands from terminal by typing mysql --command I would if possible like to be able to be able to log into mysql. I tried like this
mysqladmin -u root password myPassword that didn't work. I've only been working with unbuntu a few days.
attaboy
 
Posts: 11
Joined: 27. March 2012 17:59
Location: Boulder Creek, CA
XAMPP Version: 5.6.3
Operating System: windows XP pro, Unbuntu

Re: need to login to mysql in unbuntu

Postby attaboy » 12. April 2012 00:17

I managed to get a wizard called citidel to run, it walked me through creating a mysql account with admin rights named admin and a password but when I try to login:
mysql -u admin -p

I get this message:
root@dad-OEM:~/Desktop# mysql -u admin -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
root@dad-OEM:~/Desktop#

update:
I just found out I can access phpmyadmin from localhost (shoulda thought of that earlier) still I would like to be able to use terminal like I can use the command window in Windows.
attaboy
 
Posts: 11
Joined: 27. March 2012 17:59
Location: Boulder Creek, CA
XAMPP Version: 5.6.3
Operating System: windows XP pro, Unbuntu

Re: need to login to mysql in unbuntu

Postby JonB » 27. April 2012 17:45

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)


well that would be because this is LAMPP, not a 'LAMP' stack. Citadel (or whatever) doesn't know where mysql.sock is located.

Use phpMyAdmin for now, and familiarize yourself with where things are located in LAMPP - everything is under /opt/lampp.

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 5 guests