right... im getting quite frustrated at setting MySQL and SQL Server up... i cant connect to the server or whatnot... i dont understand.. help me!! :P

Name = nameOfDatabaseGoesHere?
Host Name = nameOfMyComputerGoesHere?
User Name = ???
Password = ???
Port = ???

ok so this might sound like childs play to u gurus but this is my first time

What platform you trying to do this in?

im trying to use MySQL with its Control Center... as well as Microsoft SQL Server 2000. both complain that it cant connect to the server or something... go figure, im dense

ok i think ive finally managed to get SQL Server 2000 running... but MySQL is still giving me problems. I start up the "winmysqladmin" program, set my username and password, and then go to "MySQL Control Center" to try to make a connection (and to make a new database). It just spews this message out "[JC] ERROR 1045: Access denied for user: 'cj@192.168.1.1' (Using password: YES)".

i have already opened port 3306 (default for MySQL). If i remove the password from the control center and try to log in, it works, but i have practically zero privileges and cant add/delete databases/users.

Sounds a lot like you're not logging into the MySQL database server as a user that has permission to log onto the server. Have you tried logging onto the database server as whatever MySQL's equivilent to SQL Server's SA account is and create a user account that has database creation privileges?

the thing is, when i first started the MySQL admin program, it prompted me for a username and password, which i have tried using to log into the server using the Control Center. it just doesnt work. and i dont know how else to add another user.

http://academic.cmri.ac.th/appserv/

Download and install that or maybe the picture tutorial on the top news section could help you.

isnt it just sa with no password?

That's the ultra-secure SQL Server default. I'm wondering if Mephist installed the full SQL Server or just MSDE? If it's the full SQL Server then he can go into it through the Enterprise Manager and create users. He might even be able to get into his MySQL server and create users there, too.

edit

heh, no, i managed to get SQL Server going fine a while ago. it was MySQL that i was having trouble with.. turns out i need to login as 'root' with no password so that i could make new users etc. got it all sussed anyway... thanks peeps

*Don Adams' voice* So, MySQL decided to be ultra-secure, too, eh? :wink:

actually, it makes perfect sense that root has no password on installation. otherwise, how the hell would you administer it?

there is no security until you set it up. that is only logical.

how would you do it lDon? set a password that is documented? tell me please what the difference is? everyone would know it by reading the install manual so what is your point exactly.

just like when you set up lunix, no root password there... and you can choose to leave it blank. same/same