Author Topic: Cannot login to database  (Read 1196 times)

0 Members and 1 Guest are viewing this topic.

Offline power-pauleTopic starter

  • Irregular
  • Posts: 1
    • View Profile
    • http://www.ghost-town.de.tf/
Cannot login to database
« on: May 20, 2003, 07:42:07 AM »
I installed MySQL and I wanted to login to my databasewith the Shell of mysql.exe with the order:
Code: [Select]
mysql -u root -p
But there\'s always the answer:
Quote
You have an error in your SQL syntax...

Who can help me?                    

Offline shivabharat

  • Addict
  • Posts: 2,404
    • View Profile
Cannot login to database
« Reply #1 on: May 20, 2003, 07:54:15 AM »
If u are using windows

u will find the mysql.exe in the mysqlbin directory

if u want to issue the command from anywere then u have to set path

C:mysqlbin>mysql -u admin -p
Enter password: *****

U can also download a  GUI based tool for windows

www.sqlyog.com                    
Knowledge --- Reading Enriches Mind But Sharing Enhances It.Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks