Results 1 to 5 of 5

Thread: MySQL question

  1. #1
    Dark Phoenix
    MySQL question
    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)

  2. #2
    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.

  3. #3

    Member Since
    Dec 11, 2004
    14" iBook 1.33 G4, 768 MB RAM, 60GB HD
    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

    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 wont appear as "test".

    Let us know if you need further help.

  4. #4
    Dark Phoenix
    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 to find nothing about the client to be inputted.. so how do I fix this?

  5. #5
    Dark Phoenix
    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... )

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. mySQL
    By burnedfaceless in forum Web Design and Hosting
    Replies: 1
    Last Post: 02-03-2014, 08:36 AM
  2. PHP MySql Security Question
    By mguise in forum Web Design and Hosting
    Replies: 0
    Last Post: 07-06-2011, 05:39 PM
  3. question about installing MySQL on a mac
    By hintbanana in forum Web Design and Hosting
    Replies: 3
    Last Post: 02-06-2008, 04:03 AM
  4. MySQL
    By ftjogoh in forum Web Design and Hosting
    Replies: 3
    Last Post: 11-21-2004, 11:29 AM
  5. mySQL question
    By gort in forum Web Design and Hosting
    Replies: 2
    Last Post: 09-28-2004, 03:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts