PhpMyAdmin multi user install troubles, help needed...

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • GH

    #1

    PhpMyAdmin multi user install troubles, help needed...

    Forgive me if this is not the correct forum, if anyone knows of a more
    sutible place please let me know...

    I have a win2003 server IIS6 and have been having fits loggin in to
    the MyPhpAdmin using a superuser account(or any account for that
    matter).

    know matter how much I read and look around, mutitude of user
    permission checks and a few changes, restarting the server, deleting
    the cookie so I can try to log in again, I consinstantly get

    Error
    MySQL said:
    #1045 - Access denied for user: 'ctl_usr@ka-boom' (Using password:
    YES)


    (I changed user names from 'pma' to 'ctl_user' in the create_table.sq l
    )

    I have read the docs 50 times, made sure I understood them (At least
    as
    far as a mutlti user env.)

    re-read them again 20 times.
    I used the create_tables.s ql in the scripts folder chose to use cookie
    authentication, made certain the ctl_usr has the correct table
    permissions on the mysql db, made certain that the config.inc.php file
    had the correct user and pass in the
    $cfg['Servers'][$i]['controluser']= ctl_usr string and
    $cfg['Servers'][$i]['controlpass'] string
    I have made certain that the $cfg['Servers'][$i]['pmadb'] string is
    set to the phpmyadmin db

    and still having the same troube 2 days later.....

    If any one here can shed some light
    please respond, your time will be appreciated !

    Glenn
  • Alexander M. Turek

    #2
    Re: PhpMyAdmin multi user install troubles, help needed...

    Hi there,

    GH wrote:[color=blue]
    > Forgive me if this is not the correct forum, if anyone knows of a more
    > sutible place please let me know...[/color]

    https://sourceforge.net/tracker/?gro...67&atid=377409

    Regards,

    Alexander M. Turek

    Comment

    • Joshua Gosse

      #3
      Re: PhpMyAdmin multi user install troubles, help needed...

      Ever try using Apache rather than IIS? It's better on virtually every level,
      IMHO.


      Comment

      • Carlos Marangon

        #4
        Re: PhpMyAdmin multi user install troubles, help needed...

        Hi!

        You need before all, open the file CONFIG.INC and configure it.
        If you try run (PHPMy Admin, PMA for short) in your localhost
        it will easily be installed because, and all you need is copy it into
        a dir, because it already come with the DB seted up.

        To run it in a server you need configure some vars in the CONFIG.INC
        file

        I hope this helps.

        Best regards,

        Carlos

        hooper1@optonli ne.net (GH) wrote in message news:<d29f3431. 0402151547.25b4 4db0@posting.go ogle.com>...[color=blue]
        > Forgive me if this is not the correct forum, if anyone knows of a more
        > sutible place please let me know...
        >
        > I have a win2003 server IIS6 and have been having fits loggin in to
        > the MyPhpAdmin using a superuser account(or any account for that
        > matter).
        >
        > know matter how much I read and look around, mutitude of user
        > permission checks and a few changes, restarting the server, deleting
        > the cookie so I can try to log in again, I consinstantly get
        >
        > Error
        > MySQL said:
        > #1045 - Access denied for user: 'ctl_usr@ka-boom' (Using password:
        > YES)
        >
        >
        > (I changed user names from 'pma' to 'ctl_user' in the create_table.sq l
        > )
        >
        > I have read the docs 50 times, made sure I understood them (At least
        > as
        > far as a mutlti user env.)
        >
        > re-read them again 20 times.
        > I used the create_tables.s ql in the scripts folder chose to use cookie
        > authentication, made certain the ctl_usr has the correct table
        > permissions on the mysql db, made certain that the config.inc.php file
        > had the correct user and pass in the
        > $cfg['Servers'][$i]['controluser']= ctl_usr string and
        > $cfg['Servers'][$i]['controlpass'] string
        > I have made certain that the $cfg['Servers'][$i]['pmadb'] string is
        > set to the phpmyadmin db
        >
        > and still having the same troube 2 days later.....
        >
        > If any one here can shed some light
        > please respond, your time will be appreciated !
        >
        > Glenn[/color]

        Comment

        • GH

          #5
          Re: PhpMyAdmin multi user install troubles, help needed...

          > > made certain the ctl_usr has the correct table[color=blue][color=green]
          > > permissions on the mysql db, made certain that the config.inc.php file
          > > had the correct user and pass in the
          > > $cfg['Servers'][$i]['controluser']= ctl_usr string and
          > > $cfg['Servers'][$i]['controlpass'] string
          > > I have made certain that the $cfg['Servers'][$i]['pmadb'] string is
          > > set to the phpmyadmin db[/color][/color]



          Carlos,
          Thanks for your reply, I did mention that I did check the
          config.inc.php
          Maybe I missed something Ill go through it again...



          [color=blue]
          >Ever try using Apache rather than IIS[/color]
          Joshua, yea i have considered it, and may just do it. unfortunatly
          for me I have a bunch of stuff set up using IIS6 and would need a few
          hours to re-configure.



          Still pulling my hair out,
          Glenn H

          Comment

          Working...