Mysql Client

Installation and configuration iussues

Moderators: macek, egami, gesf

bllott
New php-forum User
New php-forum User
Posts: 30
Joined: Sun Jan 25, 2004 9:14 pm
Location: Toronto
Contact:

Mysql Client

Postby bllott » 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)
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
New php-forum User
New php-forum User
Posts: 81
Joined: Sat May 07, 2011 12:05 am

Re: Mysql Client

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

johnj
php-forum Super User
php-forum Super User
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 pm

Re: Mysql Client

Postby johnj » 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.

victorsmith
New php-forum User
New php-forum User
Posts: 9
Joined: Tue Sep 20, 2011 11:00 pm

Re: Mysql Client

Postby victorsmith » 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


Return to “MySQL Installation”

Who is online

Users browsing this forum: No registered users and 0 guests

cron