SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2004
    Location
    Milkyway
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Login Question

    Hello everyone,

    I've installed MySQL 4.0.18, on my Windows XP Pro box, and I was amazed with the ability to login (as root) without user name and password...

    My ini file (my.ini) has the following content:

    #This File was made using the WinMySQLAdmin 1.4 Tool
    #10-05-2004 17:27:03

    #Uncomment or Add only the keys that you know how works.
    #Read the MySQL Manual for instructions

    [mysqld]
    basedir=C:/mysql
    #bind-address=192.168.0.1
    datadir=C:/mysql/data
    #language=C:/mysql/share/your language directory
    #slow query log#=
    #tmpdir#=
    #port=3306
    #set-variable=key_buffer=16M
    [WinMySQLadmin]
    Server=C:/mysql/bin/mysqld-nt.exe
    user=root
    password=xxxxxx

    Is there anyway, for me to prevent users from loging in without defining a username / password in their connection string?

    Regards and thanks in advance
    DBA
    "Money it's not everything!... There's gold, diamonds, etc..."

  2. #2
    Free your mind Toly's Avatar
    Join Date
    Sep 2001
    Location
    Panama
    Posts
    2,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You will need to setup a password for the root user. Follow these steps.
    Community Guidelines | Community FAQ

    "He that is kind is free, though he is a slave;
    he that is evil is a slave, though he be a king." - St. Augustine

  3. #3
    SitePoint Enthusiast
    Join Date
    Feb 2004
    Location
    Milkyway
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Exactly what I needed, thanks alot
    "Money it's not everything!... There's gold, diamonds, etc..."


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
  •