[__md__]

ye i am using xampp alongside myphpadmin

[carters-site]

Since you are using XAMPP I assume you installed phpMyAdmin yourself. You should have had to setup the username and password during setup/install time. I believe there is a file config.inc.php that should contain the username and password for the mysql connection phpMyAdmin should use.
Check this link out phpMyAdmin 3.3.0-dev - Documentation

If you do not know this you will need to figure out the root username/password MySQL was installed with. You can then get access.

phpMyAdmin is a tool installed for CPanel users. There are however some very nice GUI tools put out by mySQL themselves that you might find useful.

MySQL :: MySQL GUI Tools

[__md__]

Yes I managed to find that file and it says the username is root and the pass ' ' tried them both and it still does not work.... what I’m trying to do is integrate mysql and php with a user login which will be displayed in flash but I cant seem to get it working....

[palanikumark]

Just go to http://localhost/phpmyadmin/

Select phpmyadmin Database--> privileges




Thanks
Palanikumar

[carters-site]

Originally Posted by __md__

Yes I managed to find that file and it says the username is root and the pass ' ' tried them both and it still does not work.... what I’m trying to do is integrate mysql and php with a user login which will be displayed in flash but I cant seem to get it working....

The default username and password should be root and ''. Did you change them at one point in time and forget?

Also make sure the mySQL service is running.

[__md__]

thank you everyone for your replies. I was previously told that the preset username is root and i could make up my own password, but i decided to create another user and make my own username and password. But it still does not seem to be working for some reason. Do you have any knowledge in my sql php and flash integration?

[carters-site]

So you can or can not get logged into the database?

I am a little confused you created a new username and password? I assume you assigned privs and flushed the privs correct?

Some SQL to do it:
MySQL :: MySQL 5.1 Reference Manual :: 5.5.2 Adding User Accounts

As far as Flash user authentication GUI. Never done but I am guessing if you ask google you will find many examples and/or scripts to download and look at.

[__md__]

basically when i installed myphpadmin i never saw any prompts about user name and passwords it allowed me to start creating the databases straight away, also every time i open up myphpadmin it does not require me to login or anything like that. The reason why i wanted to know what they both were was because in php code which is linked to both the flash file and the database your required to input weather your using a localhost or not and your username and password.

[carters-site]

Originally Posted by __md__

basically when i installed myphpadmin i never saw any prompts about user name and passwords it allowed me to start creating the databases straight away, also every time i open up myphpadmin it does not require me to login or anything like that.

This is because the username 'root' and password '' are hard coded into that config file so you will not need to be prompted to enter your username and password, phpMyAdmin will just connect.

Originally Posted by __md__

The reason why i wanted to know what they both were was because in php code which is linked to both the flash file and the database your required to input weather your using a localhost or not and your username and password.

So you created another user and you tried using this user with the PHP file that is trying to connect to the database? What kind of error are you getting back from the connection code?
If it is something like "access denied for user@localhost" then it is a permissions problem and you need to look at the privileges u setup for that user.

I am not familiar with phpMyAdmin much more then using the SQL interface. I am more at home with a straight up MySQL client so I am not sure how you actually flush privs in phpMyAdmin it may be done automatically but someone else will have to explain that one or reference their documentation page.

[__md__]

yes basically i have created a user registration page which is displayed in flash I am surposed to get feedback when someone tries to register or login but this does not happen the code used for the flash part has no errors and the code used in the php files are also correct thats why i think it has something to do with the username and password and weather its localhost because these attributes have to be entered into the php files it probably can not link with the database for some reason.