problem accessing MySQL from ubuntu 8.04

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

problem accessing MySQL from ubuntu 8.04

Postby mjApache » 27. August 2010 10:09

hi,
i have just installed xampp on laptop and trying to write some commands in MySQL like create table and etc.my os is ubuntu 8.04.
when i start my xampp from commandline it starts normally
manasee@MJ:/opt/lampp$ sudo ./lampp start
Starting XAMPP for Linux 1.7.3a...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
manasee@MJ:/opt/lampp$
after that on http://localhost
i created a new database name mj
and wrote a query
create table "mj"."name" ("myname" varchar(10));
it gives a error message "#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"mj"."name" ("myname" varchar(10))' at line 1"
but if i create it using graphics it gets created also when i try to access mysql from terminal it gives this error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"

whats the problem?
mjApache
 
Posts: 1
Joined: 27. August 2010 09:55

Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 17 guests