ads mysql <[EMAIL PROTECTED]> wrote:
>
> I tried as advised as follows :
> I tried to uninstall mysql rpm as
> rpm -e /var/lib/mysql
> It gives following.
> [EMAIL PROTECTED] root]# rpm -e /var/lib/mysql
> error: package /var/lib/mysql is not installed
/var/lib/mysql is not a package, it's MySQL data dir.
>
> [EMAIL PROTECTED] root]# rpm -e MySQL-server-4.0.16-0.i386.rpm
> error: package MySQL-server-4.0.16-0.i386.rpm is not installed
> [EMAIL PROTECTED] root]# rpm -e MySQL-client-4.0.16-0.i386.rpm
> error: package MySQL-client-4.0.16-0.i386.rpm is not installed
> [EMAIL PROTECTED] root]# rpm -i MySQL-server-4.0.16-0.i386.rpm
> warning: MySQL-server-4.0.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
> package MySQL-server-4.0.16-0 is already installed
> [EMAIL PROTECTED] root]# rpm -i MySQL-client-4.0.16-0.i386.rpm
> warning: MySQL-client-4.0.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
> package MySQL-client-4.0.16-0 is already installed
You can see which packages are installed with:
rpm -qa | grep mysql
> [EMAIL PROTECTED] root]# /etc/init.d/mysql restart
> No mysqld pid file found. Looked for /var/lib/mysql/shastrihallweb.pid.
> [EMAIL PROTECTED] root]# Starting mysqld daemon with databases from /var/lib/mysql
> 031219 22:38:14 mysqld ended
>
> Since I could not Uninstall and tried to reinstall. But didn't worked out.
>
> Then tried as follows :
>
> First I moved mysql by mv /var/lib/mysql /var/lib/mysql_old
> Then tried "mysql_install_db"
>
> [EMAIL PROTECTED] root]# mysql_install_db
> Installing all prepared tables
> 031219 22:40:56 /usr/sbin/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:
> /usr/bin/mysqladmin -u root password 'new-password'
> /usr/bin/mysqladmin -u root -h shastrihallweb password 'new-password'
> See the manual for more instructions.
> NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
> the /usr/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 / ; /usr/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 /usr/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
> [EMAIL PROTECTED] root]# mysql
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> [EMAIL PROTECTED] root]# mysqld
> 031219 22:41:58 Can't start server: Bind on TCP/IP port: Address already in use
> 031219 22:41:58 Do you already have another mysqld server running on port: 3306 ?
> 031219 22:41:58 Aborting
> 031219 22:41:58 mysqld: Shutdown Complete
>
> I tried to stop running mysql as follows:
> [EMAIL PROTECTED] root]# /var/lib/mysql stop
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> I tried to restart as follows ;
> [EMAIL PROTECTED] mysql]# mysql restart
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>
> It's confusing for me.
> Please guide me step by step to use mysql in this case. I tried to go through
> documentation but bit difficult to understand for newbe like me.
>
Check if MySQL server is running:
ps ax | grep mysqld
If so, find where mysql.sock is located.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [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]
