Re: Newbie - Please help with createing database
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 what I login withnot really sure what id is. I do think its a permissions issue...but I dont want to touch any settings till I hear from someone who knows about this as I know squat. - Let us know what type of OS do you have this on. First guesses are persmissionsHave you set the permissions properly on the data directory for mysql? And what user is running mysql currently? When you started it, if *NIX, you should have supplied a user, i.e. bin/mysqld_safe --user=mysql This would mean that the mysql user would have to exist and have all rights to the data directory. hth Jeff - Cheers, -Ryan * * * * * * * * * * * * * * * * I'm not an expert (by any means) but are you in the mysql database when you're trying to create the new db? If so that might be the reason. What id are you using to create the table? Does this ID have the appropriate permissions to create the db? James . 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-query : CREATE DATABASE `test1` MySQL said: Can't create database 'test1'. (errno: 13) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie - Please help with createing database
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 what I login withnot really sure what id is. I do think its a permissions issue...but I dont want to touch any settings till I hear from someone who knows about this as I know squat. Cheers, -Ryan * * * * * * * * * * * * * * * * I'm not an expert (by any means) but are you in the mysql database when you're trying to create the new db? If so that might be the reason. What id are you using to create the table? Does this ID have the appropriate permissions to create the db? James . 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-query : CREATE DATABASE `test1` MySQL said: Can't create database 'test1'. (errno: 13) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie - Please help with createing database
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 what I login withnot really sure what id is. I do think its a permissions issue...but I dont want to touch any settings till I hear from someone who knows about this as I know squat. Cheers, -Ryan * * * * * * * * * * * * * * * * I'm not an expert (by any means) but are you in the mysql database when you're trying to create the new db? If so that might be the reason. What id are you using to create the table? Does this ID have the appropriate permissions to create the db? James . 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-query : CREATE DATABASE `test1` MySQL said: Can't create database 'test1'. (errno: 13) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie - Please help with createing database
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 what I login withnot really sure what id is. I do think its a permissions issue...but I dont want to touch any settings till I hear from someone who knows about this as I know squat. Cheers, -Ryan * * * * * * * * * * * * * * * * I'm not an expert (by any means) but are you in the mysql database when you're trying to create the new db? If so that might be the reason. What id are you using to create the table? Does this ID have the appropriate permissions to create the db? James . 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-query : CREATE DATABASE `test1` MySQL said: Can't create database 'test1'. (errno: 13) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie - Please help with createing database
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 what I login withnot really sure what id is. I do think its a permissions issue...but I dont want to touch any settings till I hear from someone who knows about this as I know squat. Cheers, -Ryan * * * * * * * * * * * * * * * * I'm not an expert (by any means) but are you in the mysql database when you're trying to create the new db? If so that might be the reason. What id are you using to create the table? Does this ID have the appropriate permissions to create the db? James . 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-query : CREATE DATABASE `test1` MySQL said: Can't create database 'test1'. (errno: 13) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie - Please help with createing database
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: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 246 to server version: 3.23.58 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | admin_appl | | mysql | | test | ++ 3 rows in set (0.00 sec) mysql create database test1; ERROR 1006: Can't create database 'test1'. (errno: 13) Your problems may lie in the configuration; however the fact that you can see your mysql database with tables seems to indicate that you are communicating properly. Sounds goodbut still not working :-( Any other ideas? Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie - Please help with createing database
[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 database and it gives me this error Error SQL-query : CREATE DATABASE `test1` MySQL said: Can't create database 'test1'. (errno: 13) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Error 13 means that MySQL doesn't have permissions to write to the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie - Please help with createing database
[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 prompt$ In this case, it indicates the *MySQL process* doesn't have proper file system permissions to create the new database; you need to fix that... HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie - Please help with createing database
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. Depending on how you installed MySQL, you may want to read this page also: http://www.mysql.com/doc/en/Changing_MySQL_user.html HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]