Mark Hensler — Thu, 22 Nov 2001 08:54:29 +0000

privileges/permissions.. hey, they both start with a P!

are you still using the terminal?
can you get phpMyAdmin in? I really like 2.2.1! I had hacked 2.2.0 to display the user logged in, but they added that in 2.2.1. Way kuel! Very nice admin thing added in version 2 to manage users.

Also, anytime you alter privileges, you need to FLUSH PRIVILEGES before they take effect.

What queries are you runnnig for CREATE/INSERT?
And your doing these as root, right?
Which DB are you inserting into?

nike_guy_man — Thu, 22 Nov 2001 02:57:17 +0000

Ok, so why wont it create a new table and insert values into it?
I get no error when trying to insert it.
It inserts nothing and tells me that it was unsuccessful.

mairving — Thu, 22 Nov 2001 02:53:08 +0000

MySQL generally calls them priviledges, not permissions. Same thing though. Each user can be granted certain priviledges. Priviledges to create, drop, insert, update, select, etc. Root has full priviledges.

nike_guy_man — Wed, 21 Nov 2001 22:28:03 +0000

I know what permissions are, but Mark said they were "create" permissions.
What are they? 755?
This is my home server

mairving — Wed, 21 Nov 2001 22:19:35 +0000

Permissions define what a person can or can't do in MySQL. If this is your server at home, not on the Internet, I don't know if I would bother setting up other users and permissions.

nike_guy_man — Wed, 21 Nov 2001 21:30:17 +0000

What are create permissions?

Mark Hensler — Wed, 21 Nov 2001 21:05:22 +0000

I think this is fine. The title is "MySQL error" after all.

Check the permissions for the user you are using. Make sure they have "create" permissions for that DB.

nike_guy_man — Wed, 21 Nov 2001 19:58:14 +0000

Ok I went to the MySQL site and ran through the setup again, and I can now connect, and create a database with PHP
But I can't create a table in that database.
And there are no errors saying why.
Should I ask this in the Database forum or keep it here?

nike_guy_man — Wed, 21 Nov 2001 03:54:37 +0000

mysql -u root returns this:
Error 1045: Access denied for user root@localhost (Using Password=NO)

mairving — Wed, 21 Nov 2001 03:50:09 +0000

You actually are connecting to mysql as a user since mysql is a user, with not many priviledges.

What happens when you try to connect as mysql -u root?