Board index   FAQ   Search  
Register  Login
Board index php forum :: Database MySQL Installation

Mysql Client

Installation and configuration iussues

Moderators: macek, egami, gesf

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
bllott
New php-forum User
New php-forum User
 
Posts: 30
Joined: Sun Jan 25, 2004 9:14 pm
Location: Toronto

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

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.
johnj
php-forum Super User
php-forum Super User
 
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 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
victorsmith
New php-forum User
New php-forum User
 
Posts: 9
Joined: Tue Sep 20, 2011 11:00 pm


Return to MySQL Installation

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.