Re: beginner stuff; cant create database
Wiley, E:\mysqladmin create TestDB mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'testdb'. (err no: 13)' Error 13 means permission denied. Check if the MySQL has write access to E:\. BTW, I don't think E:\ is a very good place to store your databases. I would recommend at least something like E:\data\ for this. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: wiley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 03, 2003 5:44 AM Subject: beginner stuff; cant create database Easy question for beginner. Why am I getting this error ? I just installed Mysql and I'm trying to create a database. Beginner stuff... E:\mysqladmin create TestDB mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'testdb'. (err no: 13)' thanks in advance for anything... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: beginner stuff; cant create database
what happens when mysql -utest returns an error 2002? perror 2002 says that's an unknown error. -- Jude dashielljt(at)gmpexpress-dot-net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: beginner stuff; cant create database
Put the error number in to perror in ../mysql/bin It will then tell you what the error is about. ---snip--- /usr/local/mysql/bin$ ./perror 13 Error code 13: Permission denied ---snip--- This is an operating system error. Simon -Original Message- From: wiley [mailto:[EMAIL PROTECTED]] Sent: 03 February 2003 04:44 To: [EMAIL PROTECTED] Subject: beginner stuff; cant create database Easy question for beginner. Why am I getting this error ? I just installed Mysql and I'm trying to create a database. Beginner stuff... E:\mysqladmin create TestDB mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'testdb'. (err no: 13)' thanks in advance for anything... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: beginner stuff; cant create database
perror 13 returns Error code 13: Permission denied You do not have permission to create databases as the default user. As installed. there is already a test database called 'test' and a test user called 'test' with no password to do the kind of inital trying out you probably want. May I suggest you use the mysql tool rather than the mysqladmin tool for initial playing. mysql -utest will get you in to a useful environment. mysqladmin is really only, as its name suggests, for admin purposes, not development or tryout purposes. |-+ | | wiley | | | wiley@wileycreat| | | ions.com| | || | | 03/02/2003 04:44 | | || |-+ --| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: beginner stuff; cant create database | --| Easy question for beginner. Why am I getting this error ? I just installed Mysql and I'm trying to create a database. Beginner stuff... E:\mysqladmin create TestDB mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'testdb'. (err no: 13)' thanks in advance for anything... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: beginner stuff; cant create database
Hi Error 13 is Permission denied. Check you have write permissions on the mysql database directory (you might not if you copied from a CD for instance). Hope this helps iolaire On Sun, Feb 02, 2003 at 08:44:23PM -0800, wiley wrote: Easy question for beginner. Why am I getting this error ? I just installed Mysql and I'm trying to create a database. Beginner stuff... E:\mysqladmin create TestDB mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'testdb'. (err no: 13)' thanks in advance for anything... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: beginner stuff; cant create database
On Monday 03 February 2003 06:44, wiley wrote: Easy question for beginner. Why am I getting this error ? I just installed Mysql and I'm trying to create a database. Beginner stuff... E:\mysqladmin create TestDB mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'testdb'. (err no: 13)' thanks in advance for anything... Because MySQL has no permissions on the datadir. Please check that MySQL can write to the directory where MySQL data is located. -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php