New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Web Design and Hosting Creating sites, scripting, and hosting discussions.

MySQL question


Post Reply New Thread Subscribe

 
Thread Tools
Dark Phoenix
Guest
 
Posts: n/a

How do I determine the database name, username, and password? I installed it but I have no idea what the name username and passwords are. -_-

If the root password is the password for that then thats all I've got...
(trying to install a phpbb board)
QUOTE Thanks
vtupser
Guest
 
Posts: n/a

I believe the default database when mySQL is installed is called "mysql" The username is "root" and there shouldnt be a password needed for it. The host should be localhost. You might want to dl a program to help manage it like phpMyAdmin or of the like. That way if you are not good with terminal, you can let it do all the work for you.
QUOTE Thanks
JackTheRipper

 
Member Since: Dec 11, 2004
Location: Vancouver
Posts: 128
JackTheRipper is on a distinguished road
Mac Specs: 14" iBook 1.33 G4, 768 MB RAM, 60GB HD

JackTheRipper is offline
Indeed, upon installation, mysql makes the db mysql to insert the usernames and password of those who will be usning mysql.

you know, if you have mysql on your computer (I'm guessing it's for home testing etc), as vtupser mentioned, installed phpmyadmin.

extract files to your server
edit config.inc.php

and then when phpmyadmin is working properly, open the "mysql" talbe and fromt here you can insert new users. I suggest duplicating the 'root user' row and editing it to suit your new username and password. You might have to find the resulting encoded password that will result. e.g if your password is 'test', the password stored in mysql will be encoded...it wont appear as "test".

Let us know if you need further help.
QUOTE Thanks
Dark Phoenix
Guest
 
Posts: n/a

Thanks for the help but now I have a different problem.
ok I keep messing up and then fixing it myself -_-.
Now I'm getting
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
everytime I go to the phpmyadmin in my browser
I downloaded navicat and I've looked through the config.inc to find nothing about the client to be inputted.. so how do I fix this?
QUOTE Thanks
Dark Phoenix
Guest
 
Posts: n/a

Nevermind!! did it all on my own!! Thanks for teh help guys...
I actually don't feel as dumb as I usually think I am (don't feel smarter though... )
QUOTE Thanks

Post Reply New Thread Subscribe


« freaking website | Chinese versus English »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Installing mySQl on Mac OS X sealey Web Design and Hosting 7 06-02-2005 10:45 PM
Removing MySQL from Panther 3.6 vawolf OS X - Operating System 0 12-07-2004 09:25 PM
Video production question macinsandiego Movies and Video 4 11-17-2004 07:39 AM
mySQL question gort Web Design and Hosting 2 09-28-2004 03:44 PM
Postscript question battleangel444 OS X - Operating System 2 07-09-2004 12:45 PM

All times are GMT -4. The time now is 08:22 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?