Problem ERROR 1064 (42000): You have an error in your SQL

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

Problem ERROR 1064 (42000): You have an error in your SQL

Postby neel3333 » 10. July 2005 16:21

Hey,

i recently moved to linux Cheers!!! guys for creating a wonderful soft...

On to the question...

the Lampp installed and runs just fine but

when I try to create new db using mysqladmin... it gives an error " Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)


Please help me .. all I need is to create multiple db's for other applications that I want to run using the apache..

Thanks in advance..

Neel

Edit:

I checked the forum and found the following path to start mysql: opt/lampp/bin/mysql

now the error has changd to:

mysql> mysql version;
ERROR 1064 (42000): 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 'mysql version' at line 1
mysql>


Please help....
Neel
neel3333
 
Posts: 2
Joined: 10. July 2005 16:13

Re: Problem ERROR 1064 (42000): You have an error in your SQ

Postby Dave_L » 10. July 2005 21:15

neel3333 wrote:mysql> mysql version;
ERROR 1064 (42000): 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 'mysql version' at line 1
mysql>


The error message is correct.

Here's the right way to view the mysql version:

$ /opt/lampp/bin/mysql --version
User avatar
Dave_L
 
Posts: 212
Joined: 23. October 2004 00:43

Update: How to create a db

Postby neel3333 » 11. July 2005 02:38

Thanks for your help...


I am trying to install the application TUTOS from TUTOS.ORG on linux but it requires to setup addition SQL DB. Could you please help me with some of the commands as to how to create the DB and where will it be created.

I tried the following and it went well but not sure if it created the db..

$ /opt/lampp/bin/mysqladmin -h localhost -u root -p password create DBNAME ???


Is that correct? Will create a dB?

If not I need help with the following:
1. create db with passowrd
2. grant all .... identified by password..???

Thanks in advance...
Neel
neel3333
 
Posts: 2
Joined: 10. July 2005 16:13

Postby Dave_L » 11. July 2005 05:24

Unless you really want to learn how to use the commands, it's much easier to use phpMyAdmin: http://localhost/phpmyadmin/
User avatar
Dave_L
 
Posts: 212
Joined: 23. October 2004 00:43


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 9 guests