PDA

Click to See Complete Forum and Search --> : need help FAST!

needhelp357
12-01-2003, 06:34 PM
Please help me with this!

Im trying to create a new database with mySQL in command promt, since thats the only way i know how to do it.

When i put it in and the screen looks like this..

mysql> create database forum;

i get the error..

ERROR 1044: Access denied for users '@localhost' to database 'forum'

I have my own server, its at my house and everything, and im making a database to use for my phpbb2 board.

Please Help!!
pyro
12-01-2003, 07:59 PM
Let me recommend that you use phpMyAdmin (http://www.phpmyadmin.net/) as it will make managing your databases so much easier...
needhelp357
12-01-2003, 08:35 PM
the link doesnt work!
needhelp357
12-01-2003, 09:06 PM
i dont need to manage my databases, i need to make new ones!! It says i dont have access, when its my own server!!
pyro
12-01-2003, 09:12 PM
The link works fine for me, and phpMyAdmin allows you to make databases.
DanUK
12-01-2003, 09:12 PM
Try http://www.mysql.com/documentation/mysql/bychapter/index.html.

HTH.
DanUK
12-01-2003, 09:19 PM
Not sure if this will work, just off the top of my head.

If you're using a unix-type server that is.
At the shell:


mysql --user=root mysql
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER ON yourdb.* TO theusernameyouwant@localhost IDENTIFIED BY 'pass';
needhelp357
12-02-2003, 05:07 AM
i have windows 2000
needhelp357
12-02-2003, 01:58 PM
Originally posted by skydan
Not sure if this will work, just off the top of my head.

If you're using a unix-type server that is.
At the shell:


mysql --user=root mysql
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER ON yourdb.* TO theusernameyouwant@localhost IDENTIFIED BY 'pass';


Does that only work in unix? cause your the only one who really answered my question :rolleyes:
needhelp357
12-02-2003, 04:31 PM
also, pyro, i downloaded phpadmin or w/e and now how do i make it work??
DanUK
12-02-2003, 04:36 PM
Really not sure mate, never worked any server-wise with Windows (I try and steer clear of it at best of times, Linux to begin with, and now FreeBSD (finding it difficult but getting there with teh help of books)), back to your qu sorry ;) There has to be docs that either came with your SQL or if you google, there will definitely be info there on adding a user.

Edit - first search on Google: http://www.mysql.com/doc/en/Windows_running.html

HTH.
pyro
12-02-2003, 04:46 PM
To run phpMyAdmin, just drop it on your server, and point your browser to the directory...
needhelp357
12-02-2003, 05:01 PM
i know how to create users, but it wont work it just says "you dont have acess to do it!'