Re: Newbie Query: Error starting MySQL.
Hello. Start points for you problem: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/5.0/en/starting-server.html socket=/home.dbdata/mysql/mysql.sock What is your client thinks about the location of mysqld socket? Put the same line in [client] section of my.cnf. Sanjay Arora wrote: Hi all First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2 with MySQL 4.1.12, rpm install. Changed the data directory. My /etc/my.conf --- [mysqld] datadir=/home.dbdata/mysql socket=/home.dbdata/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid - - Ran these commands for permissions: chown -R mysql:mysql /home.dbdata/mysql chmod -R go-rwx /home.dbdata/mysql Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT ps -aux shows that mysql is running though it reports failure instead of OK when I start it. Also when I stop myswl from commandline, it stops and shows OK, but cannot also connect to it. Checked the pid file mentioned in the my.cnf and it gets created and deleted when mysql starts stops respectively. Please advise what is happening and what step I have taken wrong and what to do to correct it. Am a newbie but can follow instructions. Please help. With best regards. Sanjay. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
Newbie Query: Error starting MySQL.
Hi all First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2 with MySQL 4.1.12, rpm install. Changed the data directory. My /etc/my.conf --- [mysqld] datadir=/home.dbdata/mysql socket=/home.dbdata/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid - - Ran these commands for permissions: chown -R mysql:mysql /home.dbdata/mysql chmod -R go-rwx /home.dbdata/mysql Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT ps -aux shows that mysql is running though it reports failure instead of OK when I start it. Also when I stop myswl from commandline, it stops and shows OK, but cannot also connect to it. Checked the pid file mentioned in the my.cnf and it gets created and deleted when mysql starts stops respectively. Please advise what is happening and what step I have taken wrong and what to do to correct it. Am a newbie but can follow instructions. Please help. With best regards. Sanjay. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie Query: Error starting MySQL..changed Data Directory
Hi all First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2 with MySQL 4.1.12, rpm install. Changed the data directory. My /etc/my.conf [mysqld] datadir=/home.dbdata/mysql socket=/home.dbdata/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Ran these commands for permissions: chown -R mysql:mysql /home.dbdata/mysql chmod -R go-rwx /home.dbdata/mysql Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT ps -aux shows that mysql is running 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pidmysql 6184 0.2 3.4 125808 17636 pts/0 Sl 15:47 0:01 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usrroot 6336 0.0 0.1 2920 744 pts/0R+ 15:57 0:00 ps -aux Log shows 051114 14:51:07 mysqld started 051114 14:51:08 InnoDB: Started; log sequence number 0 43634 /usr/libexec/mysqld: ready for connections. Version: '4.1.12' socket: '/home.dbdata/mysql/mysql.sock' port: 3306 Source distribution 051114 15:47:06 [Note] /usr/libexec/mysqld: Normal shutdown 051114 15:47:06 InnoDB: Starting shutdown... 051114 15:47:09 InnoDB: Shutdown completed; log sequence number 0 43634 051114 15:47:09 [Note] /usr/libexec/mysqld: Shutdown complete 051114 15:47:09 mysqld ended 051114 15:47:33 mysqld started 051114 15:47:33 InnoDB: Started; log sequence number 0 43634 /usr/libexec/mysqld: ready for connections. Version: '4.1.12' socket: '/home.dbdata/mysql/mysql.sock' port: 3306 Source distribution Please advise what I have done wrong. I suspect permissions /or incorrect data directory migration. Please help. With regards. Sanjay. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Newbie Query: Error starting MySQL..changed Data Directory
Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT This doesn't nesessarily mean that mysql hasn't started. This script waits only for certain time to check if mysql has started or not. If it is not started in that time, it simply says 'mysql start failed'. But mysql may take some more time to come up. So the best practice is to have a look at the logs (as you rightly did) to find out what exactly is going on. And your logs anyway are saying /usr/libexec/mysqld: ready for connections.. This means that mysql has started without any problems and waiting for connections. ps -aux shows that mysql is running And for the same reason I mentioned above, you are seeing this. Hope this helps. sujay -Original Message- From: Sanjay Arora [mailto:[EMAIL PROTECTED] Sent: Monday, November 14, 2005 4:46 PM To: MySql Mailing List Subject: Newbie Query: Error starting MySQL..changed Data Directory Hi all First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2 with MySQL 4.1.12, rpm install. Changed the data directory. My /etc/my.conf [mysqld] datadir=/home.dbdata/mysql socket=/home.dbdata/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Ran these commands for permissions: chown -R mysql:mysql /home.dbdata/mysql chmod -R go-rwx /home.dbdata/mysql Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT ps -aux shows that mysql is running 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pidmysql 6184 0.2 3.4 125808 17636 pts/0 Sl 15:47 0:01 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usrroot 6336 0.0 0.1 2920 744 pts/0R+ 15:57 0:00 ps -aux Log shows 051114 14:51:07 mysqld started 051114 14:51:08 InnoDB: Started; log sequence number 0 43634 /usr/libexec/mysqld: ready for connections. Version: '4.1.12' socket: '/home.dbdata/mysql/mysql.sock' port: 3306 Source distribution 051114 15:47:06 [Note] /usr/libexec/mysqld: Normal shutdown 051114 15:47:06 InnoDB: Starting shutdown... 051114 15:47:09 InnoDB: Shutdown completed; log sequence number 0 43634 051114 15:47:09 [Note] /usr/libexec/mysqld: Shutdown complete 051114 15:47:09 mysqld ended 051114 15:47:33 mysqld started 051114 15:47:33 InnoDB: Started; log sequence number 0 43634 /usr/libexec/mysqld: ready for connections. Version: '4.1.12' socket: '/home.dbdata/mysql/mysql.sock' port: 3306 Source distribution Please advise what I have done wrong. I suspect permissions /or incorrect data directory migration. Please help. With regards. Sanjay. -- 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: error starting mysql 4.1.7 cannot create/write to /root/tmp
Hello. You may specify location of temp files with 'tmpdir' server system variable. See: http://dev.mysql.com/doc/mysql/en/Temporary_files.html http://dev.mysql.com/doc/mysql/en/Server_system_variables.html Gail Lange [EMAIL PROTECTED] wrote: Hello I have just installed mysql 4.1.7 on Mandrake 10.0 (final). All went smoothly. However, when I issue the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql I get the error: Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13) When I examine the error file in /usr/local/mysql/var it says it cannto read /root and it cannot write to /root/tmp If I give others (beside root) r permission to /root and rw permissions to /root/tmp, it start up fine. I have looked as startup options for the mysqld_safe as well as the /etc/my.cnf file but have not found anyway to alter where it wants to write its temp files. Can anyone please help? Thanks, Gail -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
error starting mysql 4.1.7 cannot create/write to /root/tmp
Hello I have just installed mysql 4.1.7 on Mandrake 10.0 (final). All went smoothly. However, when I issue the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql I get the error: Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13) When I examine the error file in /usr/local/mysql/var it says it cannto read /root and it cannot write to /root/tmp If I give others (beside root) r permission to /root and rw permissions to /root/tmp, it start up fine. I have looked as startup options for the mysqld_safe as well as the /etc/my.cnf file but have not found anyway to alter where it wants to write its temp files. Can anyone please help? Thanks, Gail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error starting mysql 4.1.7 cannot create/write to /root/tmp
Hello I have just installed mysql 4.1.7 on Mandrake 10.0 (final). All went smoothly. However, when I issue the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql I get the error: Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13) When I examine the error file in /usr/local/mysql/var it says it cannto read /root and it cannot write to /root/tmp If I give others (beside root) r permission to /root and rw permissions to /root/tmp, it start up fine. I have looked as startup options for the mysqld_safe as well as the /etc/my.cnf file but have not found anyway to alter where it wants to write its temp files. Can anyone please help? Thanks, Gail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: error starting mysql 4.1.7 cannot create/write to /root/tmp
perror 13 System error: 13 = Permission denied The mysql user cannot read the /root filesystem. DVP Dathan Vance Pattishall http://www.friendster.com -Original Message- From: Gail Lange [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 10:23 AM To: [EMAIL PROTECTED] Subject: error starting mysql 4.1.7 cannot create/write to /root/tmp Hello I have just installed mysql 4.1.7 on Mandrake 10.0 (final). All went smoothly. However, when I issue the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql I get the error: Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13) When I examine the error file in /usr/local/mysql/var it says it cannto read /root and it cannot write to /root/tmp If I give others (beside root) r permission to /root and rw permissions to /root/tmp, it start up fine. I have looked as startup options for the mysqld_safe as well as the /etc/my.cnf file but have not found anyway to alter where it wants to write its temp files. Can anyone please help? Thanks, Gail -- 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: Error Starting MySQL 4.0.21
Jason Williard [EMAIL PROTECTED] wrote: I have a new linux server that I just installed the mysql-max-4.0.21-pc-linux-i686 binary on. The installation had no errors. However, it is not starting on startup because of the following error: Can't execute ./bin/mysqld_safe from dir /var/lib I can start MySQL manually running '/usr/local/mysql/bin/mysqld_safe '. Does anyone know why I am getting this error message? Because you have to start it using the full path: /usr/local/mysql/bin/mysqld_safe If you are running rpm-based linux, better take the RPM version. -- 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]
Error Starting MySQL 4.0.21
I have a new linux server that I just installed the mysql-max-4.0.21-pc-linux-i686 binary on. The installation had no errors. However, it is not starting on startup because of the following error: Can't execute ./bin/mysqld_safe from dir /var/lib I can start MySQL manually running '/usr/local/mysql/bin/mysqld_safe '. Does anyone know why I am getting this error message? Thank You, Jason Williard PCSafe, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error starting mysql
Hi, I assigned rights to a user in mysql, mysql grant all on books.* to bookorama@localhost identified by 'bookorama123'; Then I tried to access mysql in as a regular user, [bookorama@a177 bookorama]$ mysql -u bookorama books -p; Enter password: bookorama123 And I get the following error message, ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password: YES) Would someone please help me how to troubleshoot this? Thanks, Norman - 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: error starting mysql
My last email was technically correct, but not the root of your problem. Please accept my humble apologies. The answer to your problem is in the MySQL book by Paul DuBois, on page 429. If you do not have the book (and I highly recommend it), I will summarize. This situation happens if your grant tables contain the default entries installed by the mysql_install_db initialization script. It is caused by having anonymous users in your user table in the mysql database. And, it only manifests itself when you are attempting to connect via the localhost. To correct this problem, do this: % mysql -u root mysql mysql DELETE FROM user where User=; mysql FLUSH PRIVILEGES; If you have assigned a password to the root user (as I have done), you will have to do this: % mysql -u root -p mysql mysql DELETE FROM user where User=; mysql FLUSH PRIVILEGES; Again, sorry about my last email. Sincerely, Charles Quesenberry At 02:13 PM 3/7/2002 -0800, you wrote: Hi, I assigned rights to a user in mysql, mysql grant all on books.* to bookorama@localhost identified by 'bookorama123'; Then I tried to access mysql in as a regular user, [bookorama@a177 bookorama]$ mysql -u bookorama books -p; Enter password: bookorama123 And I get the following error message, ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password: YES) Would someone please help me how to troubleshoot this? Thanks, Norman - 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: error starting mysql
If you are on RedHat, you might need to do mysql grant all on books.* to [EMAIL PROTECTED] identified by 'bookorama123'; Ken Norman Zhang wrote: Hi, I assigned rights to a user in mysql, mysql grant all on books.* to bookorama@localhost identified by 'bookorama123'; Then I tried to access mysql in as a regular user, [bookorama@a177 bookorama]$ mysql -u bookorama books -p; Enter password: bookorama123 And I get the following error message, ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password: YES) Would someone please help me how to troubleshoot this? Thanks, Norman - 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
error starting mysql
i have installed MySQL on W2000 my my.ini is : [mysqld] basedir=C:/MySQL #bind-address=192.168.0.1 datadir=C:/MySQL/data #language=C:/MySQL/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M innodb_data_home_dir = c:/IbData innodb_data_file_path = ibdata1:200M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:/iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:/iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=30M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 when i run mysqld-max-nt --console i have the error message: InnoDB: operating system error number 5 in a file operation. InnoDB: operating system error number 5 in a file operation. InnoDB: Error in creating or opening c:\IbData\ibdata1 InnoDB: Could not open data files 011101 11:21:53 Can't init databases ??? - 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: error starting mysql
Hi! I looked from the MS Developer Studio manual: Code Description Name 2 The system cannot find the file specified. ERROR_FILE_NOT_FOUND 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND 4 The system cannot open the file. ERROR_TOO_MANY_OPEN_FILES 5 Access is denied. ERROR_ACCESS_DENIED Maybe you should log in to your Win2000 computer as the Administrator? when i run mysqld-max-nt --consolei have the error message: InnoDB: operating system error number 5 in a file operation. InnoDB: operating system error number 5 in a file operation. InnoDB: Error in creating or opening c:\IbData\ibdata1 InnoDB: Could not open data files011101 11:21:53 Can't init databases Regards, Heikki http://www.innodb.com/ibman.html - 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: error starting mysql
i log administrator i have created the directory c:\ibdata\ibdata1 same error.. Regards, Jean - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 10:59 AM Subject: Re: error starting mysql Hi! I looked from the MS Developer Studio manual: Code Description Name 2 The system cannot find the file specified. ERROR_FILE_NOT_FOUND 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND 4 The system cannot open the file. ERROR_TOO_MANY_OPEN_FILES 5 Access is denied. ERROR_ACCESS_DENIED Maybe you should log in to your Win2000 computer as the Administrator? when i run mysqld-max-nt --consolei have the error message: InnoDB: operating system error number 5 in a file operation. InnoDB: operating system error number 5 in a file operation. InnoDB: Error in creating or opening c:\IbData\ibdata1 InnoDB: Could not open data files011101 11:21:53 Can't init databases Regards, Heikki http://www.innodb.com/ibman.html - 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: error starting mysql
Hi! At 01:50 PM 11/1/01 -, you wrote: i log administrator i have created the directory c:\ibdata\ibdata1 Ok, that explains the error: ibdata1 should be a file. If you have a directory of the same name 'ibdata1', then Windows tries to open a DIRECTORY for reading, which does not succeed, of course. Make sure you have directories C:\ibdata and C:\iblogs but no subdirectories to these. Regards, Heikki same error.. Regards, Jean - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 10:59 AM Subject: Re: error starting mysql Hi! I looked from the MS Developer Studio manual: Code Description Name 2 The system cannot find the file specified. ERROR_FILE_NOT_FOUND 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND 4 The system cannot open the file. ERROR_TOO_MANY_OPEN_FILES 5 Access is denied. ERROR_ACCESS_DENIED Maybe you should log in to your Win2000 computer as the Administrator? when i run mysqld-max-nt --consolei have the error message: InnoDB: operating system error number 5 in a file operation. InnoDB: operating system error number 5 in a file operation. InnoDB: Error in creating or opening c:\IbData\ibdata1 InnoDB: Could not open data files011101 11:21:53 Can't init databases Regards, Heikki http://www.innodb.com/ibman.html - 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: Error starting mysql server
Weining Zhao writes: Hello, I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000 workstation. When I started mysql server with safe_mysqld, I got following error message: Start MySQL server deamon exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive 010608 10:54:45 mysqld ended The zlib installed on the workstation is version 1.1.3. Can anyone tell me what wrong here? what is this shr.o? Did I miss something? Thanks. Weining Hi! Just go to ftp.gnu.org and download zlib source. Build it and install it on AIX. Also, can you tell me what for are you using MySQL at your institution. -- Regards, For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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
Error starting mysql server
Hello, I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000 workstation. When I started mysql server with safe_mysqld, I got following error message: Start MySQL server deamon exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive 010608 10:54:45 mysqld ended The zlib installed on the workstation is version 1.1.3. Can anyone tell me what wrong here? what is this shr.o? Did I miss something? Thanks. Weining - 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