I would like some help setting up MySQL on WindowsNT please! I have installed MySQL as a service and it is working, however I have not yet set a user name and password in the ini file. I like using mysql from the command prompt window and am unsure how to access this in NT if a username and password is set. Will double clicking on mysql.exe automatically use the username and password set in the ini file?
Also, will setting the user name and password fix the following problem .... I opened mysql.exe in order to create a new database. I created the database and then wished to set a user and password for the database using the GRANT command, however when I enter the GRANT command I get and error can't access xxx database from localhost.
Any answers / help would be greatly appreciated!
Also, will setting the user name and password fix the following problem .... I opened mysql.exe in order to create a new database. I created the database and then wished to set a user and password for the database using the GRANT command, however when I enter the GRANT command I get and error can't access xxx database from localhost.
Any answers / help would be greatly appreciated!