A problem on installation of 4.0.3. First, I tried with rpm -U and when I try to uninstall it says not installed when I try to install or upgrade it says already installed
I looked at the rpm package files and try to erase them manually and they are not there So I tried the tarball ....... linux:/usr/local/mysql # scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 020911 19:21:57 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h linux password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com linux:/usr/local/mysql # Looking at .data does not show any messages =================== linux:/usr/local/mysql # ls . INSTALL-BINARY include manual_toc.html support-files .. README lib mysql-test tests COPYING bin man scripts COPYING.LIB configure manual.html share ChangeLog data manual.txt sql-bench linux:/usr/local/mysql # cd data linux:/usr/local/mysql/data # ls . .. mysql test linux:/usr/local/mysql/data # ================= Besides, the thread concurrency variable is correct as I have 2 processors: (here is /etc/my.cnf) [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer_size=500M set-variable = key_buffer=100M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = max_connections=10 set-variable = tmp_table_size=400M set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=8 set-variable = thread_concurrency=4 # Try number of CPU's*2 #set-variable = myisam_sort_buffer_size=64M set-variable = myisam_sort_buffer_size=4M innodb_data_home_dir= innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata7:2000M;ibdata8:2000M ;/usr/ibdata/ibdata9:2000M;/usr/ibdata/ibdata10:2000M;/usr/ibdata/ibdata11:2000M;/usr/ibdata/ibdata12:2000M;/ibdata/ibdata13:2000M;/ibdata/ibdata14:2000M;/ibdata/ibdata15:2000M;/var/lib/mysql/ibdata16:2000M;/var/lib/mysql/ibdata17:2000M;/var/lib/mysql/ibdata18:2000M;/var/lib/mysql/ibdata19:2000M;/var/lib/mysql/ibdata20:2000M;/var/lib/mysql/ibdata21:2000M #;/usr/ibdata/ibdata9:2000M;/usr/ibdata/ibdata10:2000M ## Comment next line if you do not need recovery(the hostname-bin.xxx files) #log-bin ## server-id = 1 #set-variable = open-files-limit=8192 #ulimit is 1024,hard 8192 set-variable = innodb_buffer_pool_size=1100M # so that innodb_buffer_pool size+key_buffer+max_connections* (sort_buffer+record_buffer+2M)=1100+100+10*(2+2+2) =1260<2000M=RAM set-variable = innodb_additional_mem_pool_size=700M set-variable = innodb_log_file_size=1000M set-variable = innodb_log_buffer_size=20M # helps for large transactions # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=384M #set-variable = bdb_max_lock=100000 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname [mysqldump] quick ------------------- THis might have been a permission issue, so I went to /usr/local/mysql/bin and changed all my* file ownerships to root root Then I ran the mysql_install_db script again and got no complaints, but still I cannot start the server. I must be doing something wrong, but can I get any hints? linux:/usr/local/mysql # scripts/mysql_install_db Installing all prepared tables 020911 19:46:49 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h linux password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com linux:/usr/local/mysql # ./bin/mysqladmin -u root password aek88ara ./bin/mysqladmin: connect to server at 'localhost' failed 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! linux:/usr/local/mysql # ls . INSTALL-BINARY include manual_toc.html support-files .. README lib mysql-test tests COPYING bin man scripts COPYING.LIB configure manual.html share ChangeLog data manual.txt sql-bench linux:/usr/local/mysql # cd bin l linux:/usr/local/mysql/bin # mysqladmin -u root password ******* bash: mysqladmin: command not found linux:/usr/local/mysql/bin # chgrp root * linux:/usr/local/mysql/bin # mysqladmin -u root password aek88ara bash: mysqladmin: command not found linux:/usr/local/mysql/bin # ls -l my* -rwxr-xr-x 1 root root 771560 Aug 24 17:39 my_print_defaults -rwxr-xr-x 1 root root 997072 Aug 24 17:39 myisamchk -rwxr-xr-x 1 root root 930672 Aug 24 17:39 myisampack -rwxr-xr-x 1 root root 855296 Aug 24 17:39 mysql -rwxr-xr-x 1 root root 3502 Aug 24 17:39 mysql_config -rwxr-xr-x 1 root root 2976 Aug 24 17:39 mysql_convert_table_format -rwxr-xr-x 1 root root 10133 Aug 24 17:39 mysql_explain_log -rwxr-xr-x 1 root root 2654 Aug 24 17:39 mysql_find_rows -rwxr-xr-x 1 root root 483 Aug 24 17:39 mysql_fix_extensions -rwxr-xr-x 1 root root 7124 Aug 24 17:39 mysql_fix_privilege_tables -rwxr-xr-x 1 root root 6186 Aug 24 17:39 mysql_secure_installation -rwxr-xr-x 1 root root 15255 Aug 24 17:39 mysql_setpermission -rwxr-xr-x 1 root root 13442 Aug 24 17:39 mysql_tableinfo -rwxr-xr-x 1 root root 3123 Aug 24 17:39 mysql_zap -rwxr-xr-x 1 root root 111547 Aug 24 17:39 mysqlaccess -rwxr-xr-x 1 root root 1702 Aug 24 16:43 mysqlaccess.conf -rwxr-xr-x 1 root root 691140 Aug 24 17:39 mysqladmin -rwxr-xr-x 1 root root 716620 Aug 24 17:39 mysqlbinlog -rwxr-xr-x 1 root root 9754 Aug 24 17:39 mysqlbug -rwxr-xr-x 1 root root 687540 Aug 24 17:39 mysqlcheck -rwxr-xr-x 1 root root 3686960 Aug 24 17:39 mysqld -rwxr-xr-x 1 root root 101224 Aug 24 17:39 mysqld.sym.gz -rwxr-xr-x 1 root root 19042 Aug 24 17:39 mysqld_multi -rwxr-xr-x 1 root root 9712 Aug 24 17:39 mysqld_safe -rwxr-xr-x 1 root root 699548 Aug 24 17:39 mysqldump -rwxr-xr-x 1 root root 4986 Aug 24 17:39 mysqldumpslow -rwxr-xr-x 1 root root 27988 Aug 24 17:39 mysqlhotcopy -rwxr-xr-x 1 root root 684772 Aug 24 17:39 mysqlimport -rwxr-xr-x 1 root root 873728 Aug 24 17:39 mysqlmanager -rwxr-xr-x 1 root root 591140 Aug 24 17:39 mysqlmanager-pwgen -rwxr-xr-x 1 root root 679632 Aug 24 17:39 mysqlmanagerc -rwxr-xr-x 1 root root 685548 Aug 24 17:39 mysqlshow -rwxr-xr-x 1 root root 715468 Aug 24 17:39 mysqltest linux:/usr/local/mysql/bin # whoami root linux:/usr/local/mysql/bin # --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
