SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast Griffinpp's Avatar
    Join Date
    Aug 2001
    Location
    Gainesville, FL
    Posts
    55
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question mysql default login?

    I've been fooling with mysql's user privilege system today, and I was wondering if there is a way to change the default user that mysql uses when someone just runs mysql, i.e.:

    c:\mysql\bin\mysql

    when I run mysql this way, there is no prompt for a password, it just dumps me straight to the mysql> prompt. The thing is that it seems to be using the root account, since I can do just about anything, including edit the mysql.user table. Any way to change this so that it prompts for a user name and password, or am I just being paranoid?
    -Paul Griffin

  2. #2
    SitePoint Enthusiast Griffinpp's Avatar
    Join Date
    Aug 2001
    Location
    Gainesville, FL
    Posts
    55
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Also, here's something wierd. I have a user "webuser" that is used for web connections. I have explicitly revoked drop and create privileges from webuser (among others):

    revoke drop on *.* from webuser;
    revoke create on *.* from webuser;

    and yet I can create and drop databases at will when I log in as webuser. Why don't the privileges apply?
    -Paul Griffin

  3. #3
    SitePoint Enthusiast Griffinpp's Avatar
    Join Date
    Aug 2001
    Location
    Gainesville, FL
    Posts
    55
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    >>moved this discussion to the php development forum, since I use mysql in conjunction with php.

    http://www.sitepointforums.com/showt...threadid=47799
    Last edited by Griffinpp; Jan 31, 2002 at 14:09.
    -Paul Griffin


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •