trivial qustion: how use mysql?

wellblue88 · 09-07-2004, 10:47 AM

I am using Redhat Enterprise and used "add/remove application" window to add mysql 3.23 to the system. How should I start to run mysql?

I tried
"mysql_install_db --user=mysql"
and got msg
"Didn't find /usr/libexec/mysqld
You should do a 'make install' before executing this script"
Does it mean the mysql sever wasn't installed yet?

I can "man safe_mysqld", but can't run "safe_mysqld". Tried to "whereis safe_mysqld", "which safe_mysqld", but can't find where it is.

Thanks ahead for your help.

bestofmed · 09-07-2004, 11:04 AM

Try this (the commands are below):

1-Go to /etc/init.d
2-check the existence of mysqld if not skip this to 6
3-run ./mysqld start (as root of course)
4-that's all just run 'mysql -u root`to start querying

Here is the full commands

Code:

$su
Password:your root password
$cd /etc/init.d
$ls mysqld
mysqld
$./mysqld start
starting MySQL                     [ OK  ]

that's all.

6-You haven't mysql server installed, just install it and it will work

GOOD LUCK

wellblue88 · 09-07-2004, 01:25 PM

Thanks for reply from bestofmed.

I didn't find "mysqld". And tried to check:
[shell]# rpm -qa |grep mysql
mysql-3.23.58-1

I tried to remove it and install new version mysql :

[shell]# rpm -e mysql-3.23.58-1
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3

[shell]# rpm -e perl-DBD-MySQL-2.1021-3
error: Failed dependencies:
perl-DBD-MySQL is needed by (installed) mysql-3.23.58-1

[shell]# rpm -ivh MySQL-server-4.0.20-0.i386.rpm
warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL conflicts with mysql-3.23.58-1

I also tried to download mysql-3.23.58-1 and install it
[shell]# rpm -ivh mysql-3.23.58-1.i386.rpm
Preparing... ########################################### [100%]
package mysql-3.23.58-1 is already installed
file /usr/bin/comp_err from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/isamchk from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/isamlog from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/my_print_defaults from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/myisamchk from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/myisamlog from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/myisampack from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/mysql from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/mysqlbinlog from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/mysqlbug from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/mysqlcheck from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/mysqldump from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/mysqlimport from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/mysqlshow from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/mysqltest from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/pack_isam from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/perror from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/replace from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/resolve_stack_dump from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/bin/resolveip from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/lib/mysql/libmysqlclient.so.10.0.0 from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/lib/mysql/libmysqlclient_r.so.10.0.0 from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/info/mysql.info.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/isamchk.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/isamlog.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/mysql.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/mysql_zap.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/mysqlaccess.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/mysqladmin.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/mysqld.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/mysqld_multi.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/mysqldump.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/perror.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/replace.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1
file /usr/share/man/man1/safe_mysqld.1.gz from install of mysql-3.23.58-1 conflicts with file from package mysql-3.23.58-1

Need more help, thanks.

david_ross · 09-07-2004, 01:31 PM

It looks like you have only installed the client - you will need to install the mysql server too.

wellblue88 · 09-07-2004, 02:34 PM

Thanks for reply from david_ross.

The problem is solved by removing packages "mysql" and "perl-DBD-MySQL" without dependency checking (otherwise they can't be removed as of recursive dependency) and installing mysql 4.0 server and client.