Re: Error 1044 Error 2003 on 4.0.13 and RH9
Here's the last couple of items from the error log.: Number of processes running now: 0 030707 21:03:37 mysqld restarted 030707 21:03:37 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 030707 21:03:37 InnoDB: Flushing modified pages from the buffer pool... 030707 21:03:37 InnoDB: Started /usr/libexec/mysqld: ready for connections. Version: '4.0.13-log' socket: '/var/lib/mysql/mysql.sock' port: 3308 030709 17:56:04 mysqld started Warning: Ignoring user change to 'root' because the user was set to 'root' earlier on the command line Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html /usr/libexec/mysqld: ready for connections A mysqld process already exists at Wed Jul 9 20:13:04 CDT 2003 A mysqld process already exists at Wed Jul 9 20:13:14 CDT 2003 A mysqld process already exists at Wed Jul 9 20:15:42 CDT 2003 A mysqld process already exists at Wed Jul 9 20:15:50 CDT 2003 030709 20:39:49 /usr/libexec/mysqld: Normal shutdown 030709 20:39:49 /usr/libexec/mysqld: Shutdown Complete 030709 20:39:49 mysqld ended 030709 21:03:48 mysqld started Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html /usr/libexec/mysqld: ready for connections A mysqld process already exists at Wed Jul 9 21:19:21 CDT 2003 Nils Valentin wrote: Hi Kevin, In this case the error log file (hostname.err) in f.e /var/lib/mysql should give you an idea whats going on. Perhaps the settings inside the my.cnf from the newer version are very different then from the older version. Best regards Nils Valentin Tokyo/Japan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
This is probably a dead horse but let me post a followup to let everyone know what I did and what has happened since. Maybe I should list it under some other error number. Before Paul posted his message I uninstalled (using rpm -e) version 4.0.13. I then got the RedHat installation CDs and reinstalled the version that came boxed with it and then got the update which makes it 3.23.56-1.9, I believe. The server would start fine. I copied the my.cnf file to /etc and added a user mysql to the mysqld section. Using mysqladmin, I can find version and status but cannot set the password for the root user and can't get processlist. When I try setting the password, I get this: [EMAIL PROTECTED] root]# mysqladmin -u root -p password 'password' Enter password: mysqladmin: unable to change password; error: 'Access denied for user: '@localhost' to database 'mysql'' I can't use FLUSH PRIVILEGES either: [EMAIL PROTECTED] root]# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 3.23.56-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql FLUSH PRIVILEGES; ERROR 1045: Access denied for user: '@localhost' (Using password: NO) I can't grant privileges: [EMAIL PROTECTED] root]# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 3.23.56-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' WITH GRANT OPTION; ERROR 1045: Access denied for user: '@localhost' (Using password: NO) mysql I notice that when the small my.cnf file that is in place when the packages first install (just 193K, I think) is used the server will stop and start just fine. When I replace that with a larger version (/usr/share/doc/mysql-server-3.23.56 on my installation) then the server will not stay running; will show Failed when I try to restart. Kevin Phillips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
Hi, Nils I was able to stop the mysqld daemon using the kill command. However, when I tried to start it using mysqld_safe --skip-grant-tables, a line would appear saying: [EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables Starting mysqld daemon with databases from /var/lib/mysql with the cursor blinking at the left-hand side of the screen with apparently nothing going on. The daemon apparently *is* started because I can ping it and get an alive signal. However, when I try granting options to root, I get an Error 1047: unknown command. (in the screen where I start the server, while the cursor is blinking, there will be no command line prompt so I have to open another terminal screen. If I type anything where the cursor is blinking in the first screen, nothing happens). Best, Kevin Nils Valentin wrote: 1) ps ax |grep mysqld to display the process ID. You will get something like 704 ?SW 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid 756 ?S 0:01 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking 923 ?S 0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking 2) kill -9 processid) That WILL stop the mysqld demon. In case you see several processes (which is more likely), just start wit the first processid shown. 3) Check again with ps ax |grep mysqld that ALL processes stopped. 4) proceed as described in my previous e-mail. 5) After having setup the rights for the root user. you should make sure that all database files are intact (myisamchk etc) Best regards Nils Valentin Tokyo/Japan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
Hi, Nils OK, here's a copy of the terminal screen I am getting after killing the mysqld daemon and then re-starting it: [EMAIL PROTECTED] root]# ps ax |grep mysqld 32309 pts/0S 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables 32334 pts/0S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mail.9-5usa.org.pid --skip-locking --skip-grant-tables 32383 pts/1S 0:00 grep mysqld [EMAIL PROTECTED] root]# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.13-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql SHOW GRANTS FOR root; ERROR 1047: Unknown command mysql GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' WITH GRANT OPTION; ERROR 1047: Unknown command mysql Here's the screen I'm getting when I start the daemon: [EMAIL PROTECTED] root]# ps ax |grep mysqld 32308 pts/0S 0:00 grep mysqld [EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables [1] 32309 [EMAIL PROTECTED] root]# Starting mysqld daemon with databases from /var/lib/mysql I hope this information helps. Thanks very much, Kevin Nils Valentin wrote: Hi Kevin; Try to start it as mysqld_safe --skip-grant-tables to start the service in the background, you will then be able to continue in the same window. Sorry I didn't mention this. Can you post the grant command you try exactly as it is to the mailing list please (without password of course ;-) Best regards Nils Valentin Tokyo/Japan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
Hi, Nils Here's what I get: mysql GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'password' WITH GRANT OPTION; ERROR 1047: Unknown command mysql I'm sorry I should have asked before if the apostrophes were necessary. And, the first one is an apostrophe and not the little tilted apostrophe (not sure of the exact term for it). Thanks, Kevin Nils Valentin wrote: Try this: mysql GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'password' WITH GRANT OPTION; Note the ' before and after [EMAIL PROTECTED] However it is a bit unusual that you dont get an error 1064 - wrong sql syntax. How did you install the mysql server (rpm or tar.gz ) ? Best regards Nils Valentin Tokyo/Japan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
Forgot to mention that I installed from an rpm. I rebuilt a source rpm. Kevin Nils Valentin wrote: How did you install the mysql server (rpm or tar.gz ) ? Best regards Nils Valentin Tokyo/Japan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
Hi, Nils I can't get the mysql server to stop! If I try service mysqld stop I get a FAILED error. If I try mysqladmin -u root -p shutdown, I get: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' [EMAIL PROTECTED] root]# If I try shutting down without using a password, I get a message saying that access is denied; I need shutdown privileges for this operation. I have pinged the server and it *says* that it is alive. Perplexing problem, no? Kevin Nils Valentin wrote: 2003 7 7 10:28Nils Valentin : Hi Kevin, try this: 1) stop the mysql server 2) mysqld_safe --skip-grant-tables 3) mysql -u root 4) mysql SHOW GRANTS FOR root; 5) GRANT ALL ON *.* TO 'root'@'%'; GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION; sorry for the mistake. Best regards Nils Valentin Tokyo/Japan 6) restart the server (without --skip-grant-table option) and try to login Best regards Nils Valentin Tokyo/Japan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
Here's what I get: mysql SELECT USER(); ++ | USER() | ++ | [EMAIL PROTECTED] | ++ 1 row in set (0.02 sec) mysql Kevin Victoria Reznichenko wrote: What is the output of SELECT USER()? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error 1044 Error 2003 on 4.0.13 and RH9
I am trying to set up mysql 4.0.13 on my RedHat 9 machine. I rebuilt the source rpm. (I had a previous installation which I deleted first). I can log on to the mysql monitor as root but can't creat databases, can't change passwords, can't grant privileges, can't select hosts, can't seem to do anything. I'm getting Errors 1044 2003. Here's some of the output: [EMAIL PROTECTED] root]# mysql -u root mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 4.0.13-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE DATABASE mydatabase; ERROR 1044: Access denied for user: '@localhost' to database 'mydatabase' mysql \q Bye [EMAIL PROTECTED] root]# mysql -u root -h 127.0.0.1 ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111) [EMAIL PROTECTED] root]# mysql -u root mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 to server version: 4.0.13-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql SHOW GRANTS FOR root; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql This may have been covered before. If so, I apologize for the repition. Thanks very much. You may e-mail me directly if you wish. Kevin Phillips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock doesn't exist
The permissions on my /var/lib/mysql directory are: File Owner: mysql - MySQL Server; Group is mysql. I did discover that I had not set a user in /etc/my.cnf. Once I did that, the mysql.sock file was set up (doh! sorry about that). Here's a portion of what I get when I do ls -l /var/lib/mysql (I'm omitting a bunch of mail-bin files): [EMAIL PROTECTED] root]# ls -l /var/lib/mysql total 21880 drwx--2 mysqlmysql4096 Nov 14 2002 9-5USA -rw-rw1 mysqlmysql 25088 Jun 19 17:17 ib_arch_log_00 -rw-rw1 mysqlmysql10485760 Jun 19 17:17 ibdata1 -rw-rw1 mysqlmysql 5242880 Jun 27 13:54 ib_logfile0 -rw-rw1 mysqlmysql 5242880 Jun 19 17:17 ib_logfile1 -rw-r--r--1 mysqlmysql 46031 Jun 27 14:08 mail.9-5usa.org.err -rw-rw1 mysqlmysql 4 Jun 27 13:54 mail.9-5usa.org.pid - - drwx--2 mysqlmysql4096 Nov 4 2002 mysql srwxrwxrwx1 mysqlmysql 0 Jun 27 13:54 mysql.sock drwx--2 mysqlmysql4096 Nov 4 2002 test [EMAIL PROTECTED] root]# Here are some portions of my /etc/my.cnf file: [client] #password = your_password port= 3308 socket = /var/lib/mysql/mysql.sock user= root # The MySQL server [mysqld] port= 3308 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 I haven't really done anything to the file except add the root user and change the port from 3306 to 3308. If I just type mysql at a shell prompt I get: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.13-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql The mysql daemon seems to have permissions set for root/root: [EMAIL PROTECTED] root]# ls -l /usr/bin/mysqld_safe -rwxr-xr-x1 root root 9915 Jun 23 15:43 /usr/bin/mysqld_safe [EMAIL PROTECTED] root]# ls -l /usr/libexec/mysqld -rwxr-xr-x1 root root 3202080 Jun 23 15:43 /usr/libexec/mysqld [EMAIL PROTECTED] root]# ls -l /var/run/mysqld total 0 [EMAIL PROTECTED] root]# ls -l /etc/rc.d/init.d/mysqld -rwxr-xr-x1 root root 1772 Jun 23 15:43 /etc/rc.d/init.d/mysqld I hope this information helps. I know that I'm in 'way over my head!!! Thanks very much to all who have responded. By the way, I wasn't sure which person was meant when referring to an e-mail message that had been bounced from a server. If it was from my server, please let me know; that may be something else I need to look into! Kevin John Nichel wrote: What's the permissions on the /var/lib/mysql directory, and what user/group is the mysql daemon set to run as in your my.cnf file? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock doesn't exist
Well, the find / -name mysql.sock didn't return anything at all so this *is* an odd predicament. Would it work if someone with a similar version e-mailed me a copy of their mysql.sock file? Kevin John Nichel wrote: It doesn't look as if you have any conflicting MySQL versions. When the server is running, have you looked for the socket (someone may have already asked you this, but I'm running out of ideas)? find / -name mysql.sock -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock doesn't exist
Yes, I installed by RPM. I have now found the error file as you mentioned. The output for the last few days is: 030621 06:49:27 mysqld started 030621 6:49:28 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 030621 6:49:28 InnoDB: Flushing modified pages from the buffer pool... 030621 6:49:28 InnoDB: Started /usr/libexec/mysqld: ready for connections. Version: '4.0.13-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 A mysqld process already exists at Mon Jun 23 10:55:32 CDT 2003 A mysqld process already exists at Mon Jun 23 10:59:02 CDT 2003 A mysqld process already exists at Mon Jun 23 11:19:42 CDT 2003 A mysqld process already exists at Mon Jun 23 11:21:32 CDT 2003 A mysqld process already exists at Mon Jun 23 12:17:43 CDT 2003 A mysqld process already exists at Mon Jun 23 13:26:53 CDT 2003 A mysqld process already exists at Mon Jun 23 16:04:24 CDT 2003 A mysqld process already exists at Mon Jun 23 16:04:31 CDT 2003 A mysqld process already exists at Mon Jun 23 16:21:38 CDT 2003 A mysqld process already exists at Tue Jun 24 08:02:47 CDT 2003 A mysqld process already exists at Tue Jun 24 13:27:15 CDT 2003 A mysqld process already exists at Tue Jun 24 13:31:30 CDT 2003 A mysqld process already exists at Tue Jun 24 16:09:39 CDT 2003 A mysqld process already exists at Tue Jun 24 16:37:12 CDT 2003 Was one of my installation attempts perhaps not removed cleanly? Kevin John Nichel wrote: Did you install by RPM? If so, look in /var/lib/mysql The file will be you machine name dot err, eg... localhost.err -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock doesn't exist
The output of the greps follows. Could it be the mysqlclient that is causing the trouble? Kevin [EMAIL PROTECTED] root]# rpm -qa | grep My MySQL-python-debuginfo-0.9.1-7 Mysql-DBI-perl-bin-1.1825-1 MySQL-shared-3.23.53a-1 qt-MySQL-3.1.1-6 MySQL-python-0.9.1-7 MyODBC-2.50.39-11 perl-DBD-MySQL-2.1021-3 [EMAIL PROTECTED] root]# rpm -qa | grep my mod_auth_mysql-1.11-12 php-mysql-4.2.2-17 mysql-4.0.13-2 mysqlclient9-3.23.22-8 libdbi-dbd-mysql-0.6.5-5 mysql-devel-4.0.13-2 mysql-debuginfo-4.0.13-2 mysql-bench-4.0.13-2 mysql-server-4.0.13-2 [EMAIL PROTECTED] root]# John Nichel wrote: Try this... rpm -qa | grep My rpm -qa | grep my If you see more than one server, then it's installed multiple times. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql.sock doesn't exist
I apologize for posting about something which has probably been covered before but I can't remember where I have seen this dealt with. I have been trying to upgrade/install/re-install MySQL 4.0.13 and when I try to do any administrative work (set root password, for example) I get this message: error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! I have run searches for the mysql.sock file and it isn't showing up on my system (RedHat 9.0 fully updated). I had rebuilt 4.0.13 from the source rpm. I thought I remembered that the mysql.sock file was created when the daemon was first run but can't remember where I saw that. Thanks for any help. You may e-mail me directly if you wish. Kevin Phillips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock doesn't exist
Yes, the server is running. One odd thing about my setup is that when I restart the service I get a Failed signal for the shutdown phase but an OK for the start phase. Thanks, Kevin Victor Pendleton wrote: Is the mysql server currently running? You can also use either -S or --socket to specify the socket connection. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock doesn't exist
The output of the grep is: [EMAIL PROTECTED] root]# ps -ax | grep mysqld 4578 ?S 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf 4601 ?S 0:01 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mail.9-5usa.org.pid --skip-locking 10785 pts/0S 0:00 grep mysqld The /var/log/boot.log files shows this for the last few entries: un 24 13:27:15 mail mysqld: Stopping MySQL: failed Jun 24 13:27:15 mail mysqld: Starting MySQL: succeeded Jun 24 13:31:30 mail mysqld: Stopping MySQL: failed Jun 24 13:31:30 mail mysqld: Starting MySQL: succeeded The /var/log/mysqld.log files shows this (it hasn't registered anything since yesterday so maybe it isn't logging???): 030623 11:16:53 mysqld ended 030623 11:17:06 mysqld started 030623 11:17:06 Can't start server: Bind on TCP/IP port: Address already in use 030623 11:17:06 Do you already have another mysqld server running on port: 3306 ? 030623 11:17:06 Aborting 030623 11:17:06 /usr/libexec/mysqld: Shutdown Complete 030623 11:17:06 mysqld ended It seems I'm locked out of doing anything at all with it. Kevin John Nichel wrote: If you get a failed when the script is stopping the server, it's more than likely that the server is dying right after it's started. When you think it's running do a ps -ax | grep mysqld If that doesn't return anything (or it only returns the grep), then the server isn't running. Check your logs to see why it's dying. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock doesn't exist
I changed the port in /etc/my.cnf and restarted the service but still get a message that I can't connect to the server, etc. I am still not seeing any fresh log messages. Why would there not be any output on that? Is there someplace I should look for a log file besides /var/log ? Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: basic 4.0.13 setup on RH9.0
Thanks for the notes. I have gotten the correct my.cnf file in place now. Now when I try to put in the password for the root user I get this: $ mysqladmin -u root password 'mypassword' mysqladmin: unable to change password; error: 'Access denied for user: '@localhost' to database 'mysql'' (I notice that there is an extra apostrophe at the end of mysql) What book or manual should I get? Thanks very much, Kevin Paul DuBois wrote: Is there something more current that I could get? Yes. :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
basic 4.0.13 setup on RH9.0
I had MySQL 3.23.56 on my RedHat machine but developed some problems (that were probably my own fault) so I decided to upgrade to 4.0. I downloaded the source rpm and rebuilt it on my system (running a fully updated RedHat 9.0). I removed the old mysql by doing rpm -e on the components; then I installed 4.0.13-2 by doing rpm -ivh on the binaries. I have copied the my-large.cnf.sh (I think that was it) from the support-files folder to /etc/my.cnf. Now when I try to set the root password, or other things, I get this message: Unknown suffix '@' used for variable 'port' (value '@MYSQL_TCP_PORT@') mysqladmin: Error while setting value '@MYSQL_TCP_PORT@' to 'port' I noticed that several of the options apparently need to have values filled in. Where can I find some good documentation on how to set up the new version? Is the O'Reilly book a good resource? I had been using one of the Red Hat Linux Bible books and also MySQL Bible by Steve Suehring. Is there something more current that I could get? You may e-mail me directly if you wish: [EMAIL PROTECTED] (or, if you have problems, [EMAIL PROTECTED]) Thanks, Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rebuild source RPM on RedHat 9.0
Hello, I just joined the list. I was trying to rebuild the MySQL 4.0.13 source RPM on my RedHat 9.0 machine. I get the following error messages at the end: make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-4.0.13/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-4.0.13' make: *** [all] Error 2 error: Bad exit status from /var/tmp/rpm-tmp.45120 (%build) RPM build errors: user mysqldev does not exist - using root user mysqldev does not exist - using root user mysqldev does not exist - using root Bad exit status from /var/tmp/rpm-tmp.45120 (%build) [EMAIL PROTECTED] src]# I don't know if that is the information anyone would need to help me. Does anyone have any suggestions on how I can deal with this problem? I have gcc-3.2.2-5. Thanks for any suggestions Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbi: mysqlgui wont connect
I have mysql working, but I can't get mysqlgui to connect. I've tried the 'bin/mysqladmin version' test and that works ok, it's just that mysqlgui doesnt connect for some reason. A test doing 'telnet localhost 3306' connects (but later disconnects, some msg about foreign host...), I just don't get what's wrong. I have whatever is latest binaries from mysql site. I'm mainly interested in having an interface that I can create some databases with and become familiar before I start trying to write some c++ code. The install is new so there's no password for 'root' user on mysql. Mysqlgui asks for a password, but then just say's it can't connect in the status bar, maybe there's an error "111" given. My apologies for such a dumb question. Any ideas, please? Kevin -- /* Kevin Hise email: [EMAIL PROTECTED] voice: 760/384-3855 WWW: http://www.ridgenet.net/~kevinh/ "There's trouble in the Kingdom send a message to the King!" - Kings-X #198118 with the Linux Counter, http://counter.li.org America kills 169 babies every hour of every day, over 38 million since 1973. http://www.roevwade.org/ http://www.abortionfacts.com/ http://www.abortioncancer.com/ http://www.nrlc.org/RU486/Index.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