Mysql Client

[bllott]

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)
mysql>

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

[Prensil]

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
http://www.prensil.com

[johnj]

..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.

[victorsmith]

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