List:General Discussion« Previous MessageNext Message »
From:bruce Date:May 16 2004 7:52am
Subject:basic mysql setup
View as plain text  
hi...

i'm running rh 8.0 with mysql on a test system. i'm relatively new to the
admin functions of mysql. another person setup the mysql on the system.

in reviewing the setup, it appears that mysql was setup with using root, and
the root password. when i look at phpMyAdmin, it is also setup using the
root. currently, it seems to provide whoever accesses the app with the
ability to make whatever changes they want!! obviously not a good thing!

can someone walk me through what i need to do to change mysql/phpMyAdmin so
that only specific users can make specific changes to the underlying
database/tables/etc...

i've taken a look at the mysql docs, and am a little confused. i've also
taken a look at the phpMyAdmin site/underlying files/docs to see if there is
a way to change the setup, but i can't seem to find what/where a change
should be made..

thanks for any help you can provide with this!!

bruce
bedouglas@stripped

Thread
optimizing insertsRon Gilbert16 May
  • basic mysql setupbruce16 May
    • Re: basic mysql setupScott Haneda16 May
      • RE: basic mysql setupbruce16 May
        • Re: basic mysql setupScott Haneda16 May
  • Re: optimizing insertsJigal van Hemert16 May
  • Re: optimizing insertsbeacker16 May
  • Re: optimizing insertsBill Allaire16 May