linux rathat5 steps to install mysql5.1

2010-12-20  来源:本站原创  分类:Database  人气:115 

1. Install linux
2. Install mysql, download the binary installation of my experience more appropriate to extract the version of the installation
http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-5.1/mysql-5.1.54-linux-i686-glibc23.tar.gz
3. After the extract mysql-5.1.54-linux-i686-glibc23.tar.gz Kaodao / user / local
Quote

This directory must be placed in the current user will have problems in later steps

mv  mysql-5.1.54-linux-i686-glibc23   /usr/local/

4. Unzip gz package to the current directory

[[email protected] local]# tar -vxf mysql-5.1.54-linux-i686-glibc23.tar.gz

5. In this step, the implementation of scripts / mysql_install_db - user = mysql If you find that there db.MYI when you look at your mysql error if copying the / usr / local in the

[[email protected] local]# groupadd  mysql
[[email protected] local]# useradd -g mysql mysql
[[email protected] local]# ln -s mysql-5.1.54-linux-i686-glibc23 mysql
[[email protected] local]# cd mysql
[[email protected] mysql]# scripts/mysql_install_db  --user=mysql
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 esunny password 'new-password'

Alternatively you can run:
./bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

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!

6. So far all the steps to get installed, and then we take a look at our database

[[email protected] mysql]# bin/mysql -uroot

The results with the error:

[[email protected] mysql]# bin/mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

After the mistake, I think a lot of ways to solve, but did not solve the problem should be the authority, but I set the tmp permissions, or error in the Web site did not find a lot of information was seen as a master of the results

I got a error message whene I completed the installation and try to start the mysql:
#mysql
ERROR 2002:Can't connect to local MySQL server through cocket '/tmp/mysql.sock'(2) 

How can I solve this problem?

 Solutions are as follows :
 The first method :You do not have mysql running when you tried to access the mysql commandline.  You first need to run

# /usr/local/etc/rc.d/mysql-server.sh start

and then you will be able to connect to mysql. 

 The second way :
#/usr/local/bin/mysqld_safe &
 And then :
#mysql

 Sure all ko

I used the second approach to solve the problem is actually not a solution, just the knowledge start mysql

相关文章
  • linux rathat5 steps to install mysql5.1 2010-12-20

    1. Install linux 2. Install mysql, download the binary installation of my experience more appropriate to extract the version of the installation http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-5.1/mysql-5.1.54-linux-i686-glibc23.tar.gz 3. After the ex

  • RedHat Linux AS5 steps to install Oracle10g 2010-11-08

    1, the hardware environment I installed the hardware environment: HP DL580 2, the software ready to install with a good standard before we first used all of the secondary package. RHEL5 installation package (five CD or a DVD) Oracle installation pack

  • SUSE Linux Enterprise Server 10 install mysql5 2010-07-10

    Make a note, huh, huh! All based on rpm install, could not find source. Because the mysql installation must rely qdbm, check before installation is already installed > Rpm-qa | grep qdbm If the display: qdbm-**** has already been installed, if nothin

  • RedHat Linux AS4 steps to install Oracle9i 2010-11-08

    groupadd dba useradd-g dba oracle passwd oracle mkdir-p / opt/oracle/product/9.2 chown-R oracle.dba / opt / chmod-R 777 / opt / Modify / etc / sysctl.conf file, add the following statement: kernel.shmmax = 1073741824 kernel.shmmni = 4096 kernel.shmal

  • linux rathat5 step installation mysql5.1 2010-12-20

    1 install linux 2 Installing mysql, download the binary installation I experience more appropriate to extract the Installation http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-5.1/mysql-5.1.54-linux-i686-glibc23.tar.gz 3 will be extracted after mysql-5

  • detailed steps to install mysql linux 2010-08-13

    Reprinted from: http://wangguorui89.javaeye.com/blog/686693 detailed steps to install mysql linux I. Introduction Want to use Linux for a long time, there is no hard task because there is no systematic study has been recently required to use Linux fo

  • Learn Linux, compile and install mysql-5.0.45.tar.gz 2011-04-24

    Compiled under Linux install mysql-5.0.45.tar.gz Reproduced <! - Body start -> (1) ------------- ---------- Preparatory work 1: If the downloaded file is named: mysql-5.0.45.tar.gz 2: If the copy to the / home under the 3: groupadd mysql # add the m

  • In suse linux enterprise 10 to install oracle 10g (with diagram) 2010-06-26

    Oracle10G minimum system requirements: Memory: Recommended 1G,, in a virtual machine for the 768M Swap partition: 1G, 2 times set of memory / Tmp disk space: 400MB or more Disk space: software, data 1.2G 3.5G Software requirements: SUSE Linux Enterpr

  • RedHat install MySQL5.0 (RPM package) Notes (rpm) 2010-10-16

    RedHat install MySQL5.0 (RPM package) Notes Online articles are mostly installed MySQL binary installation source, the steps more complex, so I will use the RPM package installation process record to others. 1, first to see if the system comes with o

  • AIX 5.3 Detailed steps to install apache 2.2.11 2010-10-31

    AIX 5.3 Detailed steps to install apache 2.2.11 weblogic port default is 7001, the application of the access path is usually http://192.168.1.1:7001/XXXWeb, the path is clear that this is too complicated for users, weblogic can modify the start of th

  • Linux operating system to install and configure the Ethernet card 2010-12-15

    Abstract With the Linux operating system is increasingly being accepted by people, how to expand the network applications on the Linux system has increasingly become issues of concern. This paper discusses the work as a network card installation and

  • RED HAT Linux operating system to install MYSQL 5.0.26 database 2011-05-10

    In the RED HAT Linux operating system to install MYSQL 5.0.26 database approach 1, download the installation files for MySQL MySQL installation requires the following two files: MySQL-server-5.0.26-0.i386.rpm MySQL-client-5.0.26-0.i386.rpm Download a

  • centos install mysql5 2011-02-11

    mysql 5.5.9 version of the 32-bit linux version Download: http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-5.5.9-1.linux2.6.i386.tar/from/http: / / ftp.jaist.ac.jp / pub / mysql / You can also use wget to download the command line sudo wget-d http:

  • RedHat install MySQL5.0 (RPM package) Notes (r) 2010-10-16

    RedHat install MySQL5.0 (RPM package) Notes Online articles are mostly installed MySQL binary code installed, the steps more complex, so I will use the RPM package installation process of record, to others. 1, take a look at whether the system comes

  • ubuntu10.04 install mysql5.1 2010-05-04

    Experience of the last manually install jdk trouble after this time decided to use Synaptic to install mysql5.1, just have the installation disk, first cdrom add to the source, use sudo apt-cdrom add command to add cdrom come, Then refresh, select my

  • [Switch] with apt-get method to install mysql5 + Apache2 + PHP5 + Phpmyadmin 2011-05-14

    Source Address: http://blogold.chinaunix.net/u/13834/showart_493981.html ======================================= ========= Began to turn ================================== Method of using apt-get install mysql5 + Apache2 + PHP5 + Phpmyadmin: Please h

  • LINUX error solve by install ORACLE 9204!! 2010-12-05

    LINUX error solve by install ORACLE 9204! ! Previous / Next 2008-10-17 12:34:05 / Personal Category: Linux View (1098) / Comments (5) / Rate (0 / 0) LINUX error solve by install ORACLE 9204! ! [Oracle @ db1 ~] $ uname-a Linux db1 2.6.9-67.ELsmp # 1 S

  • Rpm package format under Linux install mysql5 2010-10-21

    Download: http://dev.mysql.com/downloads/mysql/5.1.html mysql files are installed: the first server installed after the client installation MySQL-server-5.1.51-1.glibc23.i386.rpm MySQL-client-5.1.51-1.glibc23.i386.rpm rpm-ivh MySQL-server-5.1.51-1.gl

  • detailed steps to install linux mantis 2011-01-20

    Required Software 1.1 MySQL MySQL-server-4.1.10-0.i386.rpm MySQL-client-4.1.10-0.i386.rpm MySQL-devel-4.1.10-0.i386.rpm MySQL-shared-4.1.10-0.i386.rpm MySQL-shared-compat-4.1.10-0.i386.rpm 1.2 Apache httpd-2.0.54.tar.gz 1.3 PHP php-5.0.4.tar.gz 1.4 m

  • linux install Mysql5.0.18 2011-09-04

    1> Mysql-5.0.18.tar.gz tools via SSH upload to the Linux system's home directory 2> set up MySQL users and groups: # Groupadd mysql # Useradd-g mysql mysql Copy code 3> decompress Mysql-5.0.18.tar.gz Source package # Cd / home # Tar zxvf Mysql-5.