PDA

View Full Version : mysql problems


Darkdrizzt
06-10-2004, 12:58 PM
how do i manually create a mysql username and password if i accidently closed it when i first ran it, i already tried re-installing it and i tried going to www.mysql.com for help but nothing is working, any ideas?

monalin crusader
06-10-2004, 01:57 PM
Open the file C:\Windows\my.ini

it should look something like this


#This File was made using the WinMySQLAdmin 1.4 Tool
#5/21/2004 11:39:14 PM

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

[mysqld]
basedir=C:/mysql
#bind-address=169.254.101.152
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=(username goes here)
password=(password goes here)
QueryInterval=10


or you can open WinMySQLAdmin.exe and go to the "my.ini setup" tab

and edit it from there.

Darkdrizzt
06-10-2004, 02:34 PM
thanks you helpeda bunch now it works