what is the username when connecting to mysql

[skateme]

what is the username when connecting to mysql??? do we make it when we are installing mysql or what?? thanks in advance!

[ukdmbfan]

MySQL has root privileges by default, so you can login using your root credentials. When you've done that you can setup new users from within MySQL which is recommended so you can use them to login in the future.

[wildteen88]

try root as the username and leave the password blank

This is the default account MySQL sets up when you install it. However you can change these during installation.

[skateme]

[quote author=wildteen88 link=topic=118980.msg486664#msg486664 date=1166366471]
try root as the username and leave the password blank

This is the default account MySQL sets up when you install it. However you can change these during installation.
[/quote]
it doesn't work. it says:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mypass'@'localhost' (using password: NO) in C:\inetpub\wwwroot\login scripts\login.php on line 16
My SQL Error: Access denied for user 'mypass'@'localhost' (using password: NO)

[wildteen88]

Is mypass the username? What is the code you are using to connect to mysql post it here:

It should be like this:
[code=php:0]$conn = mysql_connect('localhost', 'root', '') or die('Connection error:<br />' . mysql_error());[/code]

If the root user doesn't work then you must of changed the password for it. You can rest the password however it is a little tricky and hard to explain.