Installing mysql-5.0.45-linux-i686-glibc23.tar.gz

2011-08-25  来源:本站原创  分类:Database  人气:183 

Install mysql
# Chmod 755 mysql-5.0.45-linux-i686-glibc23.tar.gz / / set the mysql-5.0.45-linux-i686-glibc23.tar.gz attribute 755

# Tar xzvf mysql-5.0.45-linux-i686-glibc23.tar.gz / / decompression

# Cp-r mysql-5.0.45-linux-i686-glibc23 / usr / local

# Mv mysql-5.0.45-linux-i686-glibc23 mysql

# Cd mysql

# Groupadd mysql / / mysql group established

# Useradd mysql-g mysql / / mysql user and set up a group to join mysql

# Cp / usr / local / mysql / support-files / my-medium.cnf / etc / my.cnf

In the support-files directory under the four template file, we select one as the Mysql configuration file, overwriting the / etc / my.cnf (the system default configuration, which set the performance parameters and Mysql some of the path parameter)

# Cd / usr / local / mysql into the mysql directory

#. / Scripts / mysql_install_db - user = mysql
/ / Initialize the table and provides users with access to mysql. After initializing the table began to set the mysql root user access

# Chown-R root / / set the root access to / usr / local / mysql

# Chown-R mysql data

/ / Set the mysql user to access / usr / local / mysql / data is stored inside the file mysql.

This directory is in / etc / my.cnf in configuration, generated in mysql_install_db.

# Chown-R mysql data /

/ / Set the mysql user to access / usr / local / mysql / data / mysql all files

# Chgrp-R mysql

/ / Set the mysql group access to / usr / local / mysql

# / Usr / local / mysql / bin / mysqld_safe - user = mysql &

If there is no problem running mysql, then, should appear like this prompt:

[1] 42264

# Starting mysqld daemon with databases from / usr / local / mysql / var

If mysql ended such a statement, said that Mysql does not start, you can find the problem to log in, Log files usually in / etc / my.cnf to configure. Most of the problems caused by incorrect permissions set.

# / Usr / local / mysql / bin / mysqladmin-u root password yourpassword

/ / Install a blank password by default, for security you must immediately change.

# Cp support-files/mysql.server / etc / rc.d / init.d / mysqld

Can be set to run automatically every time you start mysql

# Chmod 700 / etc / init.d / mysqld

# Chkconfig - add mysqld

# Chkconfig - level 345 mysqld on

# Service mysqld start / / start the mysqld service

# Netstat-npl | grep mysqld

/ / Check 3306 port is open. Note to open the ports in the firewall.

Close mysqladmin shutdown

相关文章
  • mysql 5.0.45 (修改)拒绝服务漏洞 2013-12-24

    mysql 5.0.45 (修改)拒绝服务漏洞的方法,追求安全的朋友可以参考下. mysql 5.0.45 (修改)拒绝服务漏洞 /* * MySQL <=6.0 possibly affected * Kristian Erik Hermansen * Credit: Joe Gallo * You must have Alter permissions to exploit this bug! * Scenario: You found SQL injection, but you want

  • linux extract the tar.gz file commands 2010-03-29

    linux extract the tar.gz file commands: tar zxvf tomcat6.0.tar.gz linux modify the file name: mv tomcat5.0 tomcat6.0 View a process: ps-ef | grep tomcat Copying files: cp filename target path to draw the machine: ether-wake target NIC address to log

  • MySQL 5.0.45启动报错处理方法 2012-09-01

    启动mysql时报错: Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 071112 00:22:06 mysqld ended 查看日志: #less /var/log/mysqld.log 其中有一段如下: 071112 0:22:06 [ERROR] /usr/local/mysql/bin/mysqld: C

  • linux install apache (tar.gz) 2010-08-10

    Transfer from: 1, http://zydky.javaeye.com/blog/553949 2, http://chmsword.javaeye.com/blog/494491 How to install Linux, apache, a lot of online information, not repeat here, but according to many online articles, the default installed apache, many mo

  • linux 安装 db2_v1012_linuxx64_expc.tar.gz 2013-05-23

    解压.安装 [[email protected] opt]# tar -xf db2_v1012_linuxx64_expc.tar.gz [[email protected] opt]# ls db2_v1012_linuxia32_expc.tar.gz expc lost+found rh [[email protected] opt]# cd expc/ [[email protected] expc]# ls db2 db2ckupgrade db2_deinstall db2_install db2ls db2prereqcheck db2set

  • Linux, Apache 2.2, MySQL 5.0 and PHP 5.0 installation and configuration 2010-12-21

    1. Installation Environment Operating System: Red Hat Linux Enterprise AS 4.0 Database: MySQL 5.0.24 Web server: Apache 2.2.3 Scripting languages: PHP 5.1.6 2. Installing MySQL 5.0.24 ------------- Download package mysql-5.0.24.tar.gz, address http:/

  • ubuntu 11.4 binaries (tar.gz) install mysql 5.5.x 2011-08-31

    For some reason, I need to use a higher one o'clock version of mysql, but ubuntu using apt-get install mysql version is not the version I expected (I used to test the ubuntu-11-04 apt-get install mysql, mysql version is 5.1 .54; ubuntu-10-04 apt-get

  • CentOS / linux under MySql 5.0.x installation. Optimization and security settings 2010-07-18

    Original Address: http://blog.chinaunix.net/u2/82530/showart_1956918.html Download page: http://dev.mysql .com/downloads/mysql/5.0.html # downloads To the bottom of the page to find the Source downloads, this is the source version, download the first

  • Installing MySQL under the free version of Linux installation and configuration records 2010-10-21

    First, the preparations Note: Because it is in a present and can be installed on the server multi-use, you need to make sure under the station is installed on the server Mysql 1, groupadd mysql mysql prompt already exists, useradd-g mysql mysql promp

  • 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

  • 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

  • Installing MYSQL on Linux 2010-11-09

    MySQL is the most famous open source database, version 5.0 is now being developed will have a lot of new features, such as stored procedures and transaction processing. MySQL performance is a step by step closer to Oracle, DB2 and other major commerc

  • Installing MySQL on Linux version of the decompression process 2010-12-01

    Installation under Linux to extract version MySQL5.1 (Download: ftp://mirror.leaseweb.com/mysql/Downloads/MySQL-5.1/) installation steps: 1, free download install MySQL version / binary version of the software (not compiled) I downloaded version is:

  • Installing MySQL under Linux source code detailed steps 2011-04-12

    1, for mysqld to add a login user and group: groupadd mysql useradd-g mysql mysql 2, download the MySQL source code, mysql-*.*.**. tar.gz, I downloaded the mysql-5.0.40.tar.gz 3, testing environment and specify the installation directory and database

  • MySQL安装与应用[Linux下的安装与配置] 2012-03-09

    Linux下的安装与配置 如果所安装的Linux系统没有内置的MySQL,笔者建议在Linux中使用RPM包来安装MySQL,同样这也是MySQL官方提供的建议.笔者接触最多的Linux系统是Radhat的"近亲":CentOS,由于CentOS较新的版本都内置了MySQL,因此在安装系统时就将MySQL安装并注册为系统服务,省去了不少工作量,此处也就不对Linux下的安装做太多陈述,仅提供部分资料供参考. 注意: MySQL至少需要Linux 2.0版本. 以下是网友提供的CentO

  • Ubuntu 9.10 install configure mysql 6.0.10 2010-07-21

    Installed to usr / local / mysql in the Unzip the file Change the name after the release of mysql Copy this folder to usr / local under sudo chmod-R 777 mysql sudo cp / usr / local / mysql / surport-file / my-small.cnf / etc / my.cnf Note The followi

  • Installing MySQL from source steps 2011-01-20

    [Note: If you need support for innodb, see below] . / Configure \ - Prefix = / usr / local / mysql \ - With-charset = utf8 \ - With-extra-charsets = all \ - With-big-tables \ - With-comment \ - With-mysqld-ldflags =- all-static \ - Enable-assembler \

  • Mysql command to uninstall Linux 2011-02-11

    centOS linux uninstall Mysql: (One) [Root @ localhost ~] # rpm-qa | grep mysql mod_auth_mysql-2.6.1-2.2 php-mysql-4.3.9-3.15 mysql-devel-4.1.20-1.RHEL4.1 mysql-4.1.20-1.RHEL4.1 mysqlclient10-3.23.58-4.RHEL4.1 libdbi-dbd-mysql-0.6.5-10.RHEL4.1 Descrip

  • mysql under linux binaries (tar.gz) installation 2010-05-22

    ubuntu is very easy to install mysql, ubuntu directly if you are running: To install MySQL, you can run the following terminal command prompt: sudo apt-get install mysql-server sudo apt-get install mysql-client sudo apt-get install php5-mysql / / Ins

  • Turn Installing Nginx with Passenger on Linux (from source) 2010-07-24

    http://www.openmymind.net/2010/7/1/Installing-Nginx-with-Passenger-on-Linux A simple guide on how to install nginx from source with passenger and ruby enterprise edition. Hopefully you've been hearing some comments over the last while about how good