MYSQL DATABASE

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hhut387
Forum Newbie
Posts: 5
Joined: Mon Jul 21, 2003 1:41 pm

MYSQL DATABASE

Post by hhut387 »

How do i know what my user name and password for my database are if i have mysql that i installed on my computer.
Coco
Forum Contributor
Posts: 339
Joined: Sat Sep 07, 2002 5:28 am
Location: Leeds, UK
Contact:

Post by Coco »

it should have asked you to provide account details when you installed it

if it didnt, you want to run the mysql admin tool that came with it, and use that to create an account (the version i have has something called 'winmysqladmin' in the bin folder)

the end result will be that your my.ini file will be edited to contain something along the lines of:

Code: Select all

їclient]
# The following password will be sent to all standard MySQL clients
user=me
password=mypass
hhut387
Forum Newbie
Posts: 5
Joined: Mon Jul 21, 2003 1:41 pm

Post by hhut387 »

Thanks a lot this worked do you know any sites that have good toturials on how to use databases
Coco
Forum Contributor
Posts: 339
Joined: Sat Sep 07, 2002 5:28 am
Location: Leeds, UK
Contact:

Post by Coco »

cant say that i do
that much took me 2 hours with the mysql website :/

other than that, this place is the best... if you try the search option at the top it quite often throws up some tasty info :)
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

...

Post by kettle_drum »

Well the mysql web site is the best for "how to run the server" stuff.

I then learn SQL commands from http://www.w3schools.com and http://www.sqlcourse.com/

Any other help that you may need im sure this forum can provide.
Post Reply