mysql

[[praetorian]]

Hi!
I havwe a couple of questions about mysql:

1) People are talking about username and password for connecting to databases, what usernames and password?
2) I've fired up winmysqladmin, but it doesn't show anything in the myODBC, it says "not found". Can I still use mysql for databases and stuff? I've tried to create a new database, but it says "The server must be connected", any ideas?

thx in advance!

[cpradio]

First question are you running this on your computer? or on a virtual server?

Second, if its on your computer you need to open the mysql config file and change the usernames and passwords for it so you can use it to connect tot he database.

-Matt

[[praetorian]]

1) on my computer
2) what file?my.ini? how should I change the info in the fil?

[cpradio]

go to your mysql folder there should be a config file or an ini file, open that in Notepage and edit the usernames and passwords

[[praetorian]]

sorry, but couldn't find any file. but what about the not found in the odbc box?

[cpradio]

Read these:
ODBC
MySQL

[scoutt]

you will have to set up a username and password before you ad tables and data. if you have propblems you can goto my site and find a bunch of tutorials on mysql to get started in windows.

[[praetorian]]

I've cheched out the two (took a sneak-peak) and installed myodbc. How do I set up the username and a password, simply how do I create a user? I can create databases, I think under localhost as username, but how do I change this?

[scoutt]

just use the dos comand box to setup the user and password.