mysql problems

Darkdrizzt · #1 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 · #2 06-10-2004, 01:57 PM

Open the file C:\Windows\my.ini

it should look something like this

Code:

#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 · #3 06-10-2004, 02:34 PM

thanks you helpeda bunch now it works