John Griffin-Wiesner writes:
> I am trying to connect to my database with mysqlgui
> as root. I have gone into "options" and entered the
> port number and the path to the socket. I have "ask for
> password" checked on and am using the same password that
> works when I do "mysql -u root -p". I have tried accessing
> the mysql db and a test one, both with the same results.
> When I try to connect and enter the password the error is:
> Access denied for user: 'root@<host.domain>' (Using password: YES)
>
> When "ask for password" is off, I get the same error plus
> more saying I have corrupt files, or no privileges. The
> entire mysql package was recently installed, and just one
> test database exists with one table. It works fine so I
> don't think I have corrupt files, and I know I have
> privileges.
>
> I have verified that mysqld is using the port with
> fuser <port#>/tcp
>
> The only problem I can think of is that this system's name
> is not resolvable via dns. It is on a non-routable network
> address behind a firewall, and just static files are used
> for internal hosts.
>
> Does mysqlgui _have_ to verify the host via dns? If so can
> that be turned off somehow?
>
> Thanks
>
> --
> John Griffin-Wiesner
> [EMAIL PROTECTED]
>
> It said, "Windows 95 or better," so I installed Linux.
>
Hi!
The above is not mysqlgui issue.
It is server that is authenticating users.
First of all, keep "Ask for password" to ON if you have one.
Second, you may start a server with --skip-name-resolve, but then you
have to grant all privileges to user@IP_address.
As mysqlgui and text mode client programs utilize the same API for
connection, they should behave the same in this respect.
Also, do not forget that for MySQL server user is actually user@host,
so that is way you must grant privileges.
If you want to grant some user privilege to login from any host, grant
privileges to user@"%".
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
