I think I just went through this.
Problem, you used root as a administrator and it doesn't actually accept it.
Follow the following how to exerpt from Abe Loveless but in place of "alumni" consider it your database.
>Creating the database:
> 1. Run "mysql_setpermission" from the command line. It will start a >program to
> assist with database and user creation. Use the following responses >to the questions:
>
> a. Select Option 2 (Add a db and user privelege for that db)
> b. DB Name: alumni
> c. DB User: alumni
> d. Y (set a password)
> e. Type a password (be sure to remember it)
> f. Re-Type it to confirm
> g. Host: localhost
> h. Add Another Host: No
> i. Implement this...: yes
> j. 0 to exit program
> 2. Type the following (without quotes) to populate your new database
> "mysql alumni < MySql-EN.sql"
>If I remember correctly, I had to use something like phpMyAdmin to view the >database and edit
Only because a database already exists I selected I believe it was option 3 to add a user and password and used a different name for instance "admin" .
I am forgetting one item which I had wrote down at work and that is how to show the databases in mysql.
I know you log into mysql and then type something like
show databases;
or something. I had a couple that I wouldn't work with because of using the word "root". But were fixed using option 3 and creating a new user and password.
Then if you can install phpMyAdmin you can see which ones you can actually connect to, to ensure they are working. Make sure you don't try to use root when setting up phpMyAdmin or you will have problems with it as well.
Now if someone can tell me how to erase the databases I set up that were not working and which I then duplicated with another name and went on to use?
Ken
10 Replies
1305 Views