MySQL 與 mysql-4.1.20-1.RHEL4.1.i386相衝突
我安裝了 redhat as 4 ,默認mysql 1.4已經安裝,
現不能刪除,
rpm -e * 不能刪除.
我應該怎麼做?
有人提出用源碼安裝,怎樣裝?
原先的mysql1.4怎辦?
《解決方案》
不能刪除就算了，但是服務一定要停。
網上查一下，找個linux下的mysql版本，直接安裝。
http://mysql.mirrors.cybercity.dk/Downloads/MySQL-5.0/
推薦：
mysql-5.0.37-linux-i686-glibc23.tar.gz
下載后打開tar -zxvf解壓，而後進入mysql-5.0目錄下，打開INSTALL文件，裡面有詳細的安裝步驟。
[ 本帖最後由 doking2008 於 2007-8-31 16:38 編輯 ]
《解決方案》
rpm -e * --force
《解決方案》
2.4.13 Installing MySQL on Other Unix-Like Systems
--------------------------------------------------
This section does not apply to MySQL Enterprise Server users.
This section covers the installation of MySQL binary distributions that
are provided for various platforms in the form of compressed `tar'
files (files with a `.tar.gz' extension). See *Note mysql-binaries::,
for a detailed list.
To obtain MySQL, see *Note getting-mysql::.
MySQL `tar' file binary distributions have names of the form
`mysql-VERSION-OS.tar.gz', where `VERSION' is a number (for example,
`5.0.40'), and OS indicates the type of operating system for which the
distribution is intended (for example, `pc-linux-i686').
In addition to these generic packages, we also offer binaries in
platform-specific package formats for selected platforms. See *Note
quick-standard-installation::, for more information on how to install
these.
You need the following tools to install a MySQL `tar' file binary
distribution:
* GNU `gunzip' to uncompress the distribution.
* A reasonable `tar' to unpack the distribution. GNU `tar' is known
to work. Some operating systems come with a preinstalled version
of `tar' that is known to have problems. For example, Mac OS X
`tar' and Sun `tar' are known to have problems with long
filenames. On Mac OS X, you can use the preinstalled `gnutar'
program. On other systems with a deficient `tar', you should
install GNU `tar' first.
If you run into problems and need to file a bug report, please use the
instructions in *Note bug-reports::.
The basic commands that you must execute to install and use a MySQL
binary distribution are:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
shell> ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
shell> cd mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
shell> bin/mysqld_safe --user=mysql &
*Note*: This procedure does not set up any passwords for MySQL
accounts. After following the procedure, proceed to *Note
post-installation::.
A more detailed version of the preceding description for installing a
binary distribution follows:
1. Add a login user and group for `mysqld' to run as:
shell> groupadd mysql
shell> useradd -g mysql mysql
These commands add the `mysql' group and the `mysql' user. The
syntax for `useradd' and `groupadd' may differ slightly on
different versions of Unix, or they may have different names such
as `adduser' and `addgroup'.
You might want to call the user and group something else instead
of `mysql'. If so, substitute the appropriate name in the
following steps.
2. Pick the directory under which you want to unpack the distribution
and change location into it. In the following example, we unpack
the distribution under `/usr/local'. (The instructions, therefore,
assume that you have permission to create files and directories in
`/usr/local'. If that directory is protected, you must perform the
installation as `root'.)
shell> cd /usr/local
3. Obtain a distribution file using the instructions in *Note
getting-mysql::. For a given release, binary distributions for all
platforms are built from the same MySQL source distribution.
4. Unpack the distribution, which creates the installation directory.
Then create a symbolic link to that directory:
shell> gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
shell> ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
The `tar' command creates a directory named `mysql-VERSION-OS'.
The `ln' command makes a symbolic link to that directory. This
lets you refer more easily to the installation directory as
`/usr/local/mysql'.
With GNU `tar', no separate invocation of `gunzip' is necessary.
You can replace the first line with the following alternative
command to uncompress and extract the distribution:
shell> tar zxvf /PATH/TO/MYSQL-VERSION-OS.tar.gz
5. Change location into the installation directory:
shell> cd mysql
You will find several files and subdirectories in the `mysql'
directory. The most important for installation purposes are the
`bin' and `scripts' subdirectories:
* The `bin' directory contains client programs and the server.
You should add the full pathname of this directory to your
`PATH' environment variable so that your shell finds the MySQL
programs properly. See *Note environment-variables::.
* The `scripts' directory contains the `mysql_install_db'
script used to initialize the `mysql' database containing the
grant tables that store the server access permissions.
6. Ensure that the distribution contents are accessible to `mysql'.
If you unpacked the distribution as `mysql', no further action is
required. If you unpacked the distribution as `root', its contents
will be owned by `root'. Change its ownership to `mysql' by
executing the following commands as `root' in the installation
directory:
shell> chown -R mysql .
shell> chgrp -R mysql .
The first command changes the owner attribute of the files to the
`mysql' user. The second changes the group attribute to the
`mysql' group.
7. If you have not installed MySQL before, you must create the MySQL
data directory and initialize the grant tables:
shell> scripts/mysql_install_db --user=mysql
If you run the command as `root', include the `--user' option as
shown. If you run the command while logged in as that user, you
can omit the `--user' option.
The command should create the data directory and its contents with
`mysql' as the owner.
After creating or updating the grant tables, you need to restart
the server manually.
8. Most of the MySQL installation can be owned by `root' if you like.
The exception is that the data directory must be owned by `mysql'.
To accomplish this, run the following commands as `root' in the
installation directory:
shell> chown -R root .
shell> chown -R mysql data
9. If you want MySQL to start automatically when you boot your
machine, you can copy `support-files/mysql.server' to the location
where your system has its startup files. More information can be
found in the `support-files/mysql.server' script itself and in
*Note automatic-start::.
10. You can set up new accounts using the `bin/mysql_setpermission'
script if you install the `DBI' and `DBD::mysql' Perl modules. See
*Note mysql-setpermission::. For Perl module installation
instructions, see *Note perl-support::.
11. If you would like to use `mysqlaccess' and have the MySQL
distribution in some non-standard location, you must change the
location where `mysqlaccess' expects to find the `mysql' client.
Edit the `bin/mysqlaccess' script at approximately line 18. Search
for a line that looks like this:
$MYSQL = '/usr/local/bin/mysql'; # path to mysql executable
Change the path to reflect the location where `mysql' actually is
stored on your system. If you do not do this, a `Broken pipe' error
will occur when you run `mysqlaccess'.
After everything has been unpacked and installed, you should test your
distribution. To start the MySQL server, use the following command:
shell> bin/mysqld_safe --user=mysql &
If you run the command as `root', you must use the `--user' option as
shown. The value of the option is the name of the login account that
you created in the first step to use for running the server. If you run
the command while logged in as `mysql', you can omit the `--user'
option.
If the command fails immediately and prints `mysqld ended', you can
find some information in the `HOST_NAME.err' file in the data directory.
More information about `mysqld_safe' is given in *Note mysqld-safe::.
*Note*: The accounts that are listed in the MySQL grant tables
initially have no passwords. After starting the server, you should set
up passwords for them using the instructions in *Note
post-installation::.
能解釋一下么?
《解決方案》
doking2008 (doking)
聖騎士
我的QQ是191581056
請求幫助
《解決方案》
qq 42709367
《解決方案》
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
shell> ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
shell> cd mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
shell> bin/mysqld_safe --user=mysql &
理解上面的每一步，mysql tar包安裝是非常方便的
《解決方案》
# cd mysqladmin
bash: cd: mysqladmin: 不是目錄
# mysqladmin -u root -p password "am770324"
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
《解決方案》
# /usr/java/mysql/bin
bash: /usr/java/mysql/bin: is a directory
# cd /usr/java/mysql/bin
# mysqladmin -u root password "123456"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
#
《解決方案》
# /usr/java/mysql/bin
bash: /usr/java/mysql/bin: is a directory
# cd /usr/java/mysql/bin
# mysqladmin -u root password "123456"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql .sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex ists!
#
# mysqld_safe --user=mysql &
10861
bash: mysqld_safe: command not found
# chown -R root
chown: 參數太少
請嘗試執行『chown --help』來獲取更多信息。
+ Exit 127 mysqld_safe --user=mysql
# cd..
bash: cd..: command not found
# cd..
bash: cd..: command not found
# cd..
bash: cd..: command not found
# cd ..
# cd ..
# cd ..
# cd ..
# chown -R root
chown: 參數太少
請嘗試執行『chown --help』來獲取更多信息。
# chown -R root .
# chown -R root /usr/java/mysql
# chgrp -R mysql /usr/java/mysql
# chown -
chown: 參數太少
請嘗試執行『chown --help』來獲取更多信息。
# chown -R mysql /usr/java/mysql/data
# cd /usr/java/mysql
# scripts/mysql_install_db --user=mysql &
10872
# Installing MySQL system tables...
OK
Filling help tables...
OK
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.
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
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 http://shop.mysql.com
# bin/mysqld_safe --user=mysql &
10902
Done scripts/mysql_install_db --user=mysql
# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
070901 08:09:11 mysqld ended
+ Done
