Re: Access denied with mysqladmin
都是中国人就说中文吧^_^ 明天会更好 On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming maxiaoming10...@hotmail.comwrote: Hi Shawn, You forgot to use -- before the option version. Try this instead mysqladmin --version Let us know your results. Oh yes, it works. When I typed the right command: mysqladmin --version I got the following result: mysqladmin Ver 8.42 Distrib 5.1.50, for Win32 on ia32 Many thanks for your help. Best Regards Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=neocana...@gmail.com
MySQL 4.0.23 wrong shared libraries output??
4.0.22 libdbug.a libmyisam.a libmysqlclient.so.12.0.0 libnisam.a libheap.a libmyisammrg.a libmysqlclient.so libmystrings.alibvio.a libmerge.a libmysqlclient.la libmysqlclient.so.12libmysys.a 4.0.23 libdbug.a libmerge.a libmyisammrg.a libmysqlclient.12 libmysqlclient.la libmysys.a libvio.a libheap.a libmyisam.a libmysqlclient libmysqlclient.12.0.0 libmystrings.a libnisam.a Note that libraries that are compiled from 4.0.23 doesn't have .so (I didn't make any typo myself) When executing ldd mysqldir/mysql linux-gate.so.1 = (0xe000) libreadline.so.4 = /usr/lib/libreadline.so.4 (0xb7fbb000) libncurses.so.5 = /usr/lib/libncurses.so.5 (0xb7f7b000) libmysqlclient.so.12 = not found Compile flags for 4.0.23 and 4.0.22 CFLAGS=-O2 -march=pentium4 -mcpu=pentium4 -fomit-frame-pointer -mmmx -msse -msse2 -mfpmath=sse CXXFLAGS=$CFLAGS ./configure --without-readline --without-bench --without-man --without-docs --with-vio --without-extra-tools --without-debug --with-unix-socket-path=/var/mysql/mysql.sock --enable-assembler --enable-shared --disable-static Anyone got this problem too? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why Mysql can't work under windowsxp
Hi can u tell me which version mysql can run under xp ? - 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
Src distribution of MySQL takes up a lot of space
Hi, I'm new to MySQL and I've recently installed MySQL (MySQL-3.23.36-1.src.rpm) and it's running ok. But, I noticed that it seems to be consuming so much of my hard disk space. Is this normal? I'm wondering if anyone encountered this problem before or can advise wat I can do abt it? Thanks, Neo - 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
URGENT: Replication problem
Hi, I am currently exploring the replication feature in 3.23.33 and encountered this error the moment I start the slave server: 010320 18:38:13 Slave: connected to master '[EMAIL PROTECTED]:9900', replication started in log 'FIRST' at posit ion 4 010320 18:38:13 Slave: received 0 length packet from server, apparent master shutdown: (0) 010320 18:38:13 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 34 010320 18:38:14 Slave: reconnected to master '[EMAIL PROTECTED]:9900',replication resumed in log 'FIRST' at posit ion 34 010320 18:38:14 Slave: received 0 length packet from server, apparent master shutdown: (0) What could be the possible reason for the error? My Master server is started with: safe_mysqld --socket=/tmp/repldb.sock --port=9900 --datadir=/home/replic/db/ mysql/data --log-bin --server-id=1 My Slave server is started with: safe_mysqld --socket=/tmp/gmdb.sock --port=9900 --datadir=/home/replic/db/my sql/data --master-host=10.1.1.0 --master-port=9900 --master-user=replicate - -master-password=replicslave --server-id=1 Thanks for any help given. Lois - 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: URGENT: Replication problem
It's my mistake, for setting the same server-id on both servers. Lois -Original Message- From: Neo Sok Lay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 March, 2001 7:41 PM To: [EMAIL PROTECTED] Subject: URGENT: Replication problem Hi, I am currently exploring the replication feature in 3.23.33 and encountered this error the moment I start the slave server: 010320 18:38:13 Slave: connected to master '[EMAIL PROTECTED]:9900', replication started in log 'FIRST' at posit ion 4 010320 18:38:13 Slave: received 0 length packet from server, apparent master shutdown: (0) 010320 18:38:13 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 34 010320 18:38:14 Slave: reconnected to master '[EMAIL PROTECTED]:9900',replication resumed in log 'FIRST' at posit ion 34 010320 18:38:14 Slave: received 0 length packet from server, apparent master shutdown: (0) What could be the possible reason for the error? My Master server is started with: safe_mysqld --socket=/tmp/repldb.sock --port=9900 --datadir=/home/replic/db/ mysql/data --log-bin --server-id=1 My Slave server is started with: safe_mysqld --socket=/tmp/gmdb.sock --port=9900 --datadir=/home/replic/db/my sql/data --master-host=10.1.1.0 --master-port=9900 --master-user=replicate - -master-password=replicslave --server-id=1 Thanks for any help given. Lois - 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
starting second mysql process gives process already exists error
Hi, I need to start 2 mysql server processes on the same box (Redhat Linux release 6.2), using the following 2 commands: bin/safe_mysqld -u root --socket=/tmp/test1.sock --port=9000 and bin/safe_mysqld -u root --socket=/tmp/test2.sock --port=9020 Previously I was using mysql 3.23.27 beta and it works fine. Now I'm switching over to the newer version 3.23.32, and I am not able to start the second process any more. The second command keeps giving me "A mysqld process already exists" message. I look into the .err file and the first command gives: 010215 17:52:50 mysqld started /usr/local/mysql-3.23.32-pc-linux-gnu-i686/bin/mysqld: ready for connections while the second gives: A mysqld process already exists at Thu Feb 15 17:53:20 SGT 2001 Is there any special setting that I need to make to solve the problem?. Any help very much appreciated. Thanks. Lois - 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