[原创]mysql 4.0.21安装经验谈

ppop123

#bin/mysqld_safe --user=mysql & /*也要用mysql用户运行，如果没任何反应，恭喜！成功了！*/
楼主这样起mysql何苦上面还要
#cp support-files/my-medium.cnf /etc/my.cnf /*这时会问是否覆盖重名文件，回答y*/

应该用
cp support-files/mysql.server /etc/
chmod +x /etc/mysql.server
/etc/mysql.server start  
这样启动mysql才是王道。

ppop123

原帖由 "akenlx" 发表：
运行mysql后，发现var目录里多了好多文件
ib_arch_log_000000000
ibdata1
ib_logfile0
ib_logfile1
localhost-bin.001
localhost-bin.002
localhost-bin.003
localhost-bin.004
localhost-bin.005
localho..........

localhost-bin.xxx
这些是binlog
如果你不需要同步库，那就打开/etc/my.cnf，找到
# Replication Master Server (default)
# binary logging is required for replication
log-bin
在log-bin前面加上#
变成
#log-bin
重起mysql就好了。

ppop123

原帖由 "shiye"]alhost root 发表：
#mysql -u root -p
-bash:mysql: command not found

/usr/local/mysql/bin/mysql -uroot
这样就可以了。

aaronbai

root@localhost mysql-4.1.8]# scripts/mysql_install_db
Neither host 'localhost.localdomain' nor 'localhost' could be looked up with
/usr/local/bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option

Johnite

[root@Johnite mysql-3.22.32-pc-linux-gnu-i686]# ./configure --prefix=/web/mysql
WARNING: Your libc libraries are not 100 % compatible with this MySQL version
mysqld should work normally with the exception that host name resolving
will not work.  This means that you should use IP addresses instead
of hostnames when specifying MySQL privileges !
Creating db table
Creating host table
Creating user table
Creating func table
Creating tables_priv table
Creating columns_priv table
./scripts/mysql_install_db: line 317:  3015 段错误                  $execdir/mysqld --bootstrap --skip-grant-tables --basedir=. --datadir=$ldata "$@"  <<END_OF_DATA
use mysql;
$c_d
$i_d

$c_h
$i_h

$c_u
$i_u

$c_f
$i_f

$c_t
$c_c
END_OF_DATA

Installation of grant tables failed!

Examine the logs in /var/lib/mysql for more information.
You can also try to start the mysqld demon with:
./bin/mysqld --skip-grant &
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:

shell>; ./bin/mysql -u root mysql
mysql>; show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!
[root@Johnite mysql-3.22.32-pc-linux-gnu-i686]#

sfz103

[root@song bin]# ./mysql
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

这个是我的出现的问题？？？
运行不行啊。


[root@song bin]# ps -aux |grep mysql
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
root      7603  0.0  0.4  6832 1076 ?        S    Jul06   0:00 /bin/sh bin/mysqld_safe --user=mysql
mysql     7620  0.0  4.9 105572 12744 ?      Sl   Jul06   0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/song.pid --skip-locking
root     16766  0.0  0.2  6204  656 pts/3    R+   11:19   0:00 grep mysql

sunj1978

请问ppop123 。

>;/usr/local/mysql/bin/mysql -uroot
>;这样就可以了。

这样是可以执行了，但我在连接其他liunx时是可以直接运行mysql -uroot的。怎么样才能在任意位置就可以运行mysql这个命令那？请高手指教。

jackylau

原帖由 "ppop123" 发表：
#bin/mysqld_safe --user=mysql & /*也要用mysql用户运行，如果没任何反应，恭喜！成功了！*/
楼主这样起mysql何苦上面还要
#cp support-files/my-medium.cnf /etc/my.cnf /*这时会问是否覆盖重名文件，回答y*/
..........

这样也不是正道.
应该这样
cd /etc/init.d
cp /usr/local/mysql/support-files/mysql.server mysql
chmod +x mysql
chkconfig --del mysql
chkconfig --add mysql

sunusa

[root@localhost mysql-standard-4.0.25-pc-linux-gnu-i686]# ./configure --prefix=/ usr/local/mysql
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
050817 19:19:32 ./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 !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h localhost.localdomain 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

Starting the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
[root@localhost mysql-standard-4.0.25-pc-linux-gnu-i686]# Starting mysqld daemon  with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
050817 19:19:32  mysqld ended

[root@localhost mysql-standard-4.0.25-pc-linux-gnu-i686]# make
make: *** No targets specified and no makefile found.  Stop.


安装的这没法继续了,makefile 没找到,另外请问高手./configure --prefix=/ usr/local/mysql是何作用?