Mysql Client

Installation and configuration iussues

Moderators: egami, macek, gesf

Post Reply
php-forum Active User
php-forum Active User
Posts: 30
Joined: Sun Jan 25, 2004 9:14 pm
Location: Toronto

Mon Feb 02, 2004 5:40 pm

Hello, I am trying to work with mysql by using the built in command-line client. The following instructions are from a book on using mysql:
The MySQL command-line client is in the /bin directory of your MySQL installation and has the file name mysql (on Unix) or mysql.exe on DOS/Windows.

If you are on Windows, you will need to go to the DOS prompt, find the path to mysql.exe, and execute it.

When you’re done, you should have something that looks very much like this:

[root@localhost root]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 716 to server version: 3.22.27-log
Type ‘help’ for help.
mysql> create database guestbook;
Query OK, 1 row affected (0.00 sec)

Then, at the prompt, create a new database by typing in:

create database database_name;
My problem is that when I locate the mysql.exe file and try to run it I get the following message:
ERROR 1045: Access denied for user: 'ODBC@localhost' <Using password: NO>
and mysql.exe does not run.

Please help me start mysql.exe
php-forum Fan User
php-forum Fan User
Posts: 81
Joined: Sat May 07, 2011 12:05 am

Tue May 17, 2011 9:26 pm

The permission is not given for that host to connect to MySQL Server. You need to allow that host to connect with Server.

Thanks and Regards,
Prensil Technologies Pvt Ltd
Software Development Company
php-forum GURU
php-forum GURU
Posts: 1803
Joined: Thu Mar 10, 2011 5:07 pm

Wed May 18, 2011 6:10 am

..You need to allow that host to connect with Server.
The error is "Access denied for user"and has nothing to do with permissions. The user credentials is not valid and that is the reason for the denied access.
New php-forum User
New php-forum User
Posts: 9
Joined: Tue Sep 20, 2011 11:00 pm

Tue Sep 20, 2011 11:15 pm

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and much more. MySQL Workbench is available on Windows, Linux and Mac OS.

Classified php script
Post Reply