Arch Linux

contrasutra

Member

From: New Jersey

Registered: 2003-07-26

Posts: 507

MySQL problems

Im installing :
Active PHP Bookmarks - lbstone.com/apb/

and the docs say to do:
bash$ mysql -u username -p database_name < database_schema.sql

the questions are: What should I put for "username"? Does it have to be an existing user, new user? What?

When trying as user "mysql" I get:
ERROR 1044: Access denied for user: '@localhost' to database 'bookmark'

Im making the database named "bookmark".

When doing as root (with root password):
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

What should I do?

Thanks.

---

"Contrary to popular belief, penguins are not the salvation of modern technology.  Neither do they throw parties for the urban proletariat."

red_over_blue

Member

Registered: 2003-07-19

Posts: 152

Re: MySQL problems

Try looking here:

http://www.linuxhelp.net/guides/mysql/

It shows you how to create users, give them permissions on the databases, etc.

I would think that you have to create a database, either as root, or as the new user you created (if you gave him permission to create new databases).  If you create the db as root, you can then give the normal user permissions on that database. 

I'll try this on my own and see how it works.

---

Don't forget to post your PKGBUILD in your thread when you announce a new package in incoming.
see HERE for details

contrasutra

Member

From: New Jersey

Registered: 2003-07-26

Posts: 507

Re: MySQL problems

Thanks, I figured it out.

But for some reason, I get strange errors when running the PHP scripts, even though I think everything is set up right.

Im going to play with it more in the morning.

---

"Contrary to popular belief, penguins are not the salvation of modern technology.  Neither do they throw parties for the urban proletariat."