Make sure you use the complete line of syntax mysqladmin -u username -p -h hostname create databasename password: (enter the password to that userid here)
Oh yeah.... sql query . ~Kelly W. Black -----Original Message----- From: john [mailto:john@;cllug.org] Sent: Monday, November 04, 2002 3:53 PM To: [EMAIL PROTECTED] Subject: Newbie help needed with mysql When I start safe_mysqld &, I get a command prompt back again and ps aux shows this: mysql 30269 0.0 0.1 10580 1024 pts/1 S 17:38 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/rock.pid mysql 30271 0.0 0.1 10580 1024 pts/1 S 17:38 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/rock.pid mysql 30272 0.0 0.1 10580 1024 pts/1 S 17:38 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/rock.pid Next I tried this: mysqladmin create testDB and I got this error: root@rock:/archives# mysqladmin create testDB mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists! I havent found any info on this online as I did a search for: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111) Both at the list archive at mysql.com and with google. I bet I could refine my search, but I dont know where to start. Please help. Thanks. John [EMAIL PROTECTED] --------------------------------------------------------------------- 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
