Page 1 of 1

problem accessing MySQL from ubuntu 8.04

PostPosted: 27. August 2010 10:09
by mjApache
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?