Can someone advise me what I should look for to correct the following error message that's preventing me from using phpmysqladmin:

Error
MySQL said:

Host 'myhost' is not allowed to connect to this MySQL server

 Thanks in advance for any suggestions or comments.

                    -- L. James

L. D. James
ljames@apollo3.com
http://www.apollo3.com/~ljames

     Thanks for the comment.  Believe me, I've been reading the docs for hours.  I was reading the mysql docs.  I uninstalled and reinstalled it many times.  I searched google for many references and got finally got this far.

 I noticed that there is a php interface that will help in administering mysql.  So I'm trying to install this while at the same time I'm still reading the docs for both PHP and MYSQL and PHPMysqlAdmin.

 I apprecite the links you gave me.  I'm studying these links.  I believe I have pinpointed what might help with the problem.

    From the docs:

    Host ... is not allowed to connect to this MySQL server

    You can fix this by using the command-line tool mysql (on the server host!) to add a row to the user, db, or host table for the user/hostname combination from which you are trying to connect and then execute mysqladmin flush-privileges. If you are not running MySQL Version 3.22 and you don't know the IP number or hostname of the machine from which you are connecting, you should put an entry with '%' as the Host column value in the user table and restart mysqld with the --log option on the server machine. After trying to connect from the client machine, the information in the MySQL log will indicate how you really did connect. (Then replace the '%' in the user table entry with the actual hostname that shows up in the log. Otherwise, you'll have a system that is insecure.) Another reason for this error on Linux is that you are using a binary MySQL version that is compiled with a different glibc version than the one you are using. In this case you should either upgrade your OS/glibc or download the source MySQL version and compile this yourself. A source RPM is normally trivial to compile and install, so this isn't a big problem.

     I'm very leary of making to many changes to the defaul user's tables because I don't want to break it.  But I guess it wouldn't hurt that much at this point because if it becomes broken early in the game, I won't have lost to much data to delete everything and reinstall.

 From reading the DOCS, lines above it seems that I'll have to add "myhost" to the user, db, or host table.  I was hoping to use the PHPMysqlAdmin to do this editing and adding.

 If you'd know the command line that might do this, I'd appreciate another hint.  I was concern that there might have been other elements that might have to be done.  If I edit the wrong thing, trying to fix something that isn't broken, I might lock myself further out.

 Again, I appreciate your comments, and any assistance you can give me in getting it started with some defaults.  From there I'll continue some of the tutorials that I see online.

                         -- L. James

    L. D. James
    ljames@apollo3.com
    http://www.apollo3.com/~ljames

    vincent wrote:

    Start by reading the manual:
    http://www.mysql.com/doc/P/r/Privilege_system.html
    http://www.mysql.com/doc/G/R/GRANT.html

      • [deleted]

      • Post #4

      Never EVER add anything to the admin tabels.

      Always use the GRANT statement:

      GRANT <privileges> ON database.tables TO user@host IDENTIFIED BY 'password';

      Never ever try to do this manually, you will f*ck up.

        Write a Reply...