Re: Newbie - Please help with createing database

2004-03-15 Thread jeffrey_n_Dyke
Hey, Thanks for replying. I login with username "root" and a password I set in the ensim control panel, it works perfectly. I dont really know if I am "in the mysql database"...but there are a couple of tables or dbs there... >What id are you using to create the table? I guess root, coz thats wha

Re: Newbie - Please help with createing database

2004-03-13 Thread Hassan Schroeder
Ryan A wrote: prompt$ perror 13 Error code 13: Permission denied Can you give me directions or a URL which will explain how to fix this please...am a newbie remember :-) Assuming you're on some sort of *nix system, `man chmod` will show you how to change permissions of files and directories. De

Re: Newbie - Please help with createing database

2004-03-13 Thread Hassan Schroeder
[EMAIL PROTECTED] wrote: mysql> create database test1; ERROR 1006: Can't create database 'test1'. (errno: 13) In the bin directory of your installation, you should have a program named 'perror' that will interpret MySQL error messages, as in: prompt$ perror 13 Error code 13: Permission denied pr

Re: Newbie - Please help with createing database

2004-03-13 Thread Egor Egorov
[EMAIL PROTECTED] wrote: > . > Hi, > After 4 hours I am finally seeing a bit of results...am a newbie in MySql > and have just been able to setup PHPMyAdmin, > after loggin in I see the database MySql and 6 tables: > columns_priv > db > func > host > tables_priv > user > > I then tried to create a

Re: Newbie - Please help with createing database

2004-03-13 Thread ryan
Hey James, Thanks for replying. > How do you like ensim? Pretty good, quite easy to use...Got it free with my hosting so no complaints. > BTW - I use the > CLI(command line interface) and connect using the mysql CLI: Ok, tried it via CLI and heres the output # mysql -u root -p Enter password:

Re: Newbie - Please help with createing database

2004-03-13 Thread ryan
Hey, Thanks for replying. I login with username "root" and a password I set in the ensim control panel, it works perfectly. I dont really know if I am "in the mysql database"...but there are a couple of tables or dbs there... >What id are you using to create the table? I guess root, coz that

Re: Newbie - Please help with createing database

2004-03-13 Thread ryan
Hey, Thanks for replying. I login with username "root" and a password I set in the ensim control panel, it works perfectly. I dont really know if I am "in the mysql database"...but there are a couple of tables or dbs there... >What id are you using to create the table? I guess root, coz that

Re: Newbie - Please help with createing database

2004-03-13 Thread ryan
Hey, Thanks for replying. I login with username "root" and a password I set in the ensim control panel, it works perfectly. I dont really know if I am "in the mysql database"...but there are a couple of tables or dbs there... >What id are you using to create the table? I guess root, coz that

Re: Newbie - Please help with createing database

2004-03-13 Thread ryan
Hey, Thanks for replying. I login with username "root" and a password I set in the ensim control panel, it works perfectly. I dont really know if I am "in the mysql database"...but there are a couple of tables or dbs there... >What id are you using to create the table? I guess root, coz that

Newbie - Please help with createing database

2004-03-13 Thread ryan
. Hi, After 4 hours I am finally seeing a bit of results...am a newbie in MySql and have just been able to setup PHPMyAdmin, after loggin in I see the database MySql and 6 tables: columns_priv db func host tables_priv user I then tried to create a database and it gives me this error Error SQL

Re: createing database

2001-10-30 Thread Carl Troein
Franck Collineau writes: > I have read the manual again. > I can connect as root (i type: mysql -u root -p then password and i have the > prompt) > > But when i type: mysql --user=root mysql > i have the message: > ERROR 1045: Access denied for user: 'root@localhost' (using password NO) mysql

RE: createing database

2001-10-29 Thread massey
-Message d'origine- > De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Envoyé : lundi 29 octobre 2001 17:23 > À : [EMAIL PROTECTED] > Objet : Re: createing database > > > You need to setup your permisions in MySQL. Look in the MySQL reference > material on how

Re: createing database

2001-10-29 Thread Carl Troein
COLLINEAU Franck FTRD/DMI/TAM writes: > I have read the manual. > > I don't understand because when i type: SELECT VERSION(), CURRENT_DATE; > it's OK, the server answer to me!! > > > > I have the error message: > > ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' If yo

Re: createing database

2001-10-29 Thread massey
You need to setup your permisions in MySQL. Look in the MySQL reference material on how to setup users and permisions. M;) > Hi! > > I have the mysql prompt. > mysql> > > I type : > > mysql> CREATE DATABASE menagerie; > > I have the error message: > ERROR 1044: Access denied for user: '@localho

createing database

2001-10-29 Thread COLLINEAU Franck FTRD/DMI/TAM
Hi! I have the mysql prompt. mysql> I type : mysql> CREATE DATABASE menagerie; I have the error message: ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' ?? Franck - Before posting, please check: