reinstalacja mysql'a
Radek
Dzis stanalem przed zadaniem przeniesienia BD z jednego serwera na drugi
no i co bylo raczej oczywiste rozjechalo sie kodowanie, 4 godziny walki
i stwierdzilem ze przeinstaluje serwer mysql'a, zeby podczas pierwszego
uruchomienia przekonfigurowac go poprawnie (tak samo jak serwer z
ktorego migruje)
i dupa... ostani raz z baza mialem kontakt zaraz przed drobna
modyfikacja pliku /etc/my.cnf potem dostawalem tylko blad serwera mysql
1405 - could not login root@ip_kompa_na_ktorym mialem phpMyAdmin w
przgladarce...
przywrocilem my.cnf do stanu przed modyfikacja i tez lipa, no wiec
yum'em odinstalowalem serwer (odinstalowalo sie kilka innych pakietow) i
ponowna instalacja, i dupa, dalej blad 1405, potem jak zaczalem jeszcze
dlubac, (przy okazji update phpmyadmin), to blad zmienil sie chyba na nr
200.
JAK WYCZYSCIC SERWER Z z silnika MYSQL (oraz konfigu)i OD ZERA go na nim
zainstalować, zeby był "dziewiczy" :)
z opcją default-charset=latin2
pzodrawiam
Radek
ER
> zainstalować, zeby był "dziewiczy" :)
> z opcją default-charset=latin2
/etc/rc.d/init.d/mysqld stop
cd /usr/local/src/mysql
./configure --prefix=/usr/local/mysql \
--with-unix-socket-path=/usr/local/mysql/mysql.sock \
--localstatedir=/usr/local/mysql/data \
--enable-assembler \
--with-pthread \
--with-charset=latin2
make
make install
/usr/local/src/mysql/scripts/mysql_install_db
cp /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysqld
chmod 700 /etc/rc.d/init.d/mysqld
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc3.d/S99mysql
/etc/rc.d/init.d/mysqld start
--
Pozdrawiam
Er
mailto:er2002@##WYKASUJ##poczta.onet.pl
Radek
>
> /etc/rc.d/init.d/mysqld stop
> cd /usr/local/src/mysql
> ./configure --prefix=/usr/local/mysql \
> --with-unix-socket-path=/usr/local/mysql/mysql.sock \
> --localstatedir=/usr/local/mysql/data \
> --enable-assembler \
> --with-pthread \
> --with-charset=latin2
>
> make
> make install
>
> /usr/local/src/mysql/scripts/mysql_install_db
>
> cp /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysqld
> chmod 700 /etc/rc.d/init.d/mysqld
> ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc3.d/S99mysql
> /etc/rc.d/init.d/mysqld start
może być to, chyba phpmyadmin krzyczal cos o problmeach z socket'em serwera
Radek
>> nim zainstalować, zeby był "dziewiczy" :)
>> z opcją default-charset=latin2
>
> /etc/rc.d/init.d/mysqld stop
> cd /usr/local/src/mysql
[root@host etc]# find / -name mysql
/usr/share/mysql
/usr/lib/mysql
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBD/mysql
/usr/bin/mysql
/root/php-5.2.11/ext/mysql
/var/lib/mysql
[root@host etc]#
a to dosaje jak wrzuce find:
PS instalowalem mysql przez yum install mysql
[root@KSIEGOWOSC etc]# find / -name *mysql*
/etc/rc.d/rc2.d/K36mysqld
/etc/rc.d/rc5.d/K36mysqld
/etc/rc.d/rc6.d/K36mysqld
/etc/rc.d/rc3.d/K36mysqld
/etc/rc.d/rc0.d/K36mysqld
/etc/rc.d/init.d/mysqld
/etc/rc.d/rc1.d/K36mysqld
/etc/rc.d/rc4.d/K36mysqld
/etc/php.d/mysql.ini
/etc/php.d/mysqli.ini
/etc/php.d/pdo_mysql.ini
/etc/ld.so.conf.d/mysql-i386.conf
/usr/libexec/mysqld
/usr/libexec/mysqlmanager
/usr/share/pixmaps/comps/mysql.png
/usr/share/info/mysql.info.gz
/usr/share/pear/MDB2/Driver/Native/mysql.php
/usr/share/pear/MDB2/Driver/Datatype/mysql.php
/usr/share/pear/MDB2/Driver/mysql.php
/usr/share/pear/MDB2/Driver/Manager/mysql.php
/usr/share/pear/MDB2/Driver/Function/mysql.php
/usr/share/pear/MDB2/Driver/Reverse/mysql.php
/usr/share/pear/.registry/mdb2_driver_mysql.reg
/usr/share/pear/.pkgxml/MDB2_Driver_mysql.xml
/usr/share/pear/DB/mysqli.php
/usr/share/pear/DB/mysql.php
/usr/share/pear/test/MDB2/tests/MDB2_nonstandard_mysqli.php
/usr/share/pear/test/MDB2/tests/MDB2_nonstandard_mysql.php
/usr/share/pear/test/MDB2_Driver_mysql
/usr/share/pear/test/MDB2_Driver_mysql/tests/MDB2_nonstandard_mysql.php
/usr/share/pear/data/MDB2_Driver_mysql
/usr/share/pear/data/MDB2_Driver_mysql/package_mysql.xml
/usr/share/mysql
/usr/share/mysql/mysql_test_data_timezone.sql
/usr/share/mysql/mysql_system_tables_data.sql
/usr/share/mysql/mysql_fix_privilege_tables.sql
/usr/share/mysql/mysql_system_tables.sql
/usr/share/zsh/4.2.6/functions/_mysql_utils
/usr/share/zsh/4.2.6/functions/_mysqldiff
/usr/share/doc/mysql-server-5.0.77
/usr/share/doc/selinux-policy-2.4.6/html/services_mysql.html
/usr/share/doc/mysql-5.0.77
/usr/share/doc/mysql-connector-odbc-3.51.26r1127
/usr/share/man/man1/mysql_setpermission.1.gz
/usr/share/man/man1/mysql_secure_installation.1.gz
/usr/share/man/man1/mysqld_safe.1.gz
/usr/share/man/man1/mysql_convert_table_format.1.gz
/usr/share/man/man1/mysql_upgrade.1.gz
/usr/share/man/man1/msql2mysql.1.gz
/usr/share/man/man1/mysqlcheck.1.gz
/usr/share/man/man1/mysqlshow.1.gz
/usr/share/man/man1/mysql_tzinfo_to_sql.1.gz
/usr/share/man/man1/mysqldumpslow.1.gz
/usr/share/man/man1/mysqlman.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysql_explain_log.1.gz
/usr/share/man/man1/mysql_waitpid.1.gz
/usr/share/man/man1/mysqlbinlog.1.gz
/usr/share/man/man1/safe_mysqld.1.gz
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysqld_multi.1.gz
/usr/share/man/man1/mysql_config.1.gz
/usr/share/man/man1/mysqlaccess.1.gz
/usr/share/man/man1/mysqlhotcopy.1.gz
/usr/share/man/man1/mysqlbug.1.gz
/usr/share/man/man1/mysql_fix_privilege_tables.1.gz
/usr/share/man/man1/mysqltest.1.gz
/usr/share/man/man1/mysql_fix_extensions.1.gz
/usr/share/man/man1/mysql_tableinfo.1.gz
/usr/share/man/man1/mysqlimport.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysql_find_rows.1.gz
/usr/share/man/man1/mysql.server.1.gz
/usr/share/man/man1/mysql_install_db.1.gz
/usr/share/man/man1/mysql_zap.1.gz
/usr/share/man/man3/DBD::mysql::INSTALL.3pm.gz
/usr/share/man/man3/Bundle::DBD::mysql.3pm.gz
/usr/share/man/man3/DBD::mysql.3pm.gz
/usr/share/man/man8/mysqlmanager.8.gz
/usr/share/man/man8/mysqld.8.gz
/usr/share/vim/vim70/syntax/mysql.vim
/usr/lib/mysql
/usr/lib/mysql/libmysqlclient.so.15
/usr/lib/mysql/mysql_config
/usr/lib/mysql/libmysqlclient_r.so.15
/usr/lib/mysql/libmysqlclient.so.15.0.0
/usr/lib/mysql/libmysqlclient_r.so.15.0.0
/usr/lib/mysql/mysqlbug
/usr/lib/dbd/libdbdmysql.so
/usr/lib/dbd/libdbdmysql.la
/usr/lib/dbd/libdbdmysql.a
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBD/mysql
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBD/mysql.pm
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/Bundle/DBD/mysql.pm
/usr/lib/php/modules/pdo_mysql.so
/usr/lib/php/modules/mysql.so
/usr/lib/php/modules/mysqli.so
/usr/lib/python2.4/site-packages/_mysql_exceptions.pyc
/usr/lib/python2.4/site-packages/_mysql_exceptions.pyo
/usr/lib/python2.4/site-packages/_mysql_exceptions.py
/usr/lib/python2.4/site-packages/_mysql.so
/usr/bin/mysqlaccess
/usr/bin/mysqltestmanager-pwgen
/usr/bin/mysql_waitpid
/usr/bin/mysql_upgrade_shell
/usr/bin/mysql_find_rows
/usr/bin/mysql_secure_installation
/usr/bin/mysql_convert_table_format
/usr/bin/mysql_fix_extensions
/usr/bin/mysqldump
/usr/bin/mysql_fix_privilege_tables
/usr/bin/mysqld_safe
/usr/bin/mysqlbinlog
/usr/bin/mysqltestmanager
/usr/bin/mysql
/usr/bin/mysql_install_db
/usr/bin/mysqlimport
/usr/bin/msql2mysql
/usr/bin/mysql_config
/usr/bin/mysqlhotcopy
/usr/bin/mysql_upgrade
/usr/bin/mysql_setpermission
/usr/bin/mysqld_multi
/usr/bin/mysqltestmanagerc
/usr/bin/mysql_tzinfo_to_sql
/usr/bin/mysql_tableinfo
/usr/bin/mysqltest
/usr/bin/mysqladmin
/usr/bin/mysqlshow
/usr/bin/mysqlcheck
/usr/bin/mysqldumpslow
/usr/bin/mysql_explain_log
/usr/bin/mysql_zap
/usr/bin/mysqlbug
/root/php-5.2.11/ext/mysql
/root/php-5.2.11/ext/mysql/mysql.dsp
/root/php-5.2.11/ext/mysql/php_mysql.h
/root/php-5.2.11/ext/mysql/php_mysql_structs.h
/root/php-5.2.11/ext/mysql/mysql.mak
/root/php-5.2.11/ext/mysql/php_mysql.c
/root/php-5.2.11/ext/pdo_mysql
/root/php-5.2.11/ext/pdo_mysql/pdo_mysql.c
/root/php-5.2.11/ext/pdo_mysql/php_pdo_mysql.h
/root/php-5.2.11/ext/pdo_mysql/mysql_statement.c
/root/php-5.2.11/ext/pdo_mysql/php_pdo_mysql_int.h
/root/php-5.2.11/ext/pdo_mysql/php_pdo_mysql_sqlstate.h
/root/php-5.2.11/ext/pdo_mysql/mysql_driver.c
/root/php-5.2.11/ext/pgsql/mysql_users.php
/root/php-5.2.11/ext/mysqli
/root/php-5.2.11/ext/mysqli/mysqli_fe.c
/root/php-5.2.11/ext/mysqli/mysqli_driver.c
/root/php-5.2.11/ext/mysqli/mysqli_report.h
/root/php-5.2.11/ext/mysqli/mysqli_report.c
/root/php-5.2.11/ext/mysqli/mysqli_exception.c
/root/php-5.2.11/ext/mysqli/mysqli_embedded.c
/root/php-5.2.11/ext/mysqli/mysqli_repl.c
/root/php-5.2.11/ext/mysqli/mysqli_warning.c
/root/php-5.2.11/ext/mysqli/mysqli.c
/root/php-5.2.11/ext/mysqli/mysqli_prop.c
/root/php-5.2.11/ext/mysqli/mysqli_nonapi.c
/root/php-5.2.11/ext/mysqli/mysqli_api.c
/root/php-5.2.11/ext/mysqli/mysqli.dsp
/root/php-5.2.11/ext/mysqli/php_mysqli.h
/root/php-5.2.11/ext/date/tests/strtotime-mysql.phpt
/root/php-5.2.11/ext/date/tests/strtotime-mysql-64bit.phpt
/root/phpMyAdmin-3.2.3-all-languages/libraries/mysql_charsets.lib.php
/root/phpMyAdmin-3.2.3-all-languages/libraries/dbi/mysqli.dbi.lib.php
/root/phpMyAdmin-3.2.3-all-languages/libraries/dbi/mysql.dbi.lib.php
/root/phpMyAdmin-3.2.3-all-languages/scripts/upgrade_tables_mysql_4_1_2+.sql
/root/.mysql_history
/root/phpMyAdmin/libraries/mysql_charsets.lib.php
/root/phpMyAdmin/libraries/dbi/mysqli.dbi.lib.php
/root/phpMyAdmin/libraries/dbi/mysql.dbi.lib.php
/root/phpMyAdmin/scripts/create_tables_mysql_4_1_2+.sql
/root/phpMyAdmin/scripts/upgrade_tables_mysql_4_1_2+.sql
/var/run/mysqld
/var/log/mysqld.log.rpmsave
/var/log/mysqld.log
/var/lib/mysql
/var/www/html/phpMyAdmin_old/libraries/mysql_charsets.lib.php
/var/www/html/phpMyAdmin_old/libraries/dbi/mysqli.dbi.lib.php
/var/www/html/phpMyAdmin_old/libraries/dbi/mysql.dbi.lib.php
/var/www/html/phpMyAdmin_old/scripts/create_tables_mysql_4_1_2+.sql
/var/www/html/phpMyAdmin_old/scripts/upgrade_tables_mysql_4_1_2+.sql
/var/www/html/phpMyAdmin/libraries/mysql_charsets.lib.php
/var/www/html/phpMyAdmin/libraries/dbi/mysqli.dbi.lib.php
/var/www/html/phpMyAdmin/libraries/dbi/mysql.dbi.lib.php
/var/www/html/phpMyAdmin/scripts/create_tables_mysql_4_1_2+.sql
/var/www/html/phpMyAdmin/scripts/upgrade_tables_mysql_4_1_2+.sql
ER
> ok tyko ze w katalogu nie mam nic... a zwłaszcza katalogu mysql :(
To co Ci wyslalem wczesniej dotyczylo kompilacji i instalacji ze zrodel.
Zwykle rozpakowuje sie zrodla w /usr/local/src/ a instaluje do
/usr/local ale to jest w gestii admina gdzie i jak chce instalowac soft.