[1]  

 没有/etc/my.cnf；

rpm包安装的MySQL是不会安装/etc/my.cnf文件的；处理：cp /usr/share/mysql/my-huge.cnf /etc/my.cnf

[2]

设置密码；

/usr/bin/mysqladmin -u root  password   新密码

重新登录验证

mysql -u root –p   新密码

mysql -u root -p   直接回车

# /usr/bin/mysqlmysql                       mysqld_safe                 mysql_setpermissionmysqlaccess                 mysqldump                   mysqlshowmysqladmin                  mysqldumpslow               mysqlslapmysqlbinlog                 mysql_embedded              mysqltestmysqlbug                    mysql_find_rows             mysqltest_embeddedmysqlcheck                  mysql_fix_extensions        mysql_tzinfo_to_sqlmysql_client_test           mysqlhotcopy                mysql_upgrademysql_client_test_embedded  mysqlimport                 mysql_waitpidmysql_config                mysql_install_db            mysql_zapmysql_convert_table_format  mysql_plugin                mysqld_multi                mysql_secure_installation

 

[3]

创建一库，创建一用户，授权该用户拥有该库的全权；

mysql>create database xxxDB;

mysql>create user xxx identified by '333';

mysql>grant all privileges on xxxDB.* to xxx;

mysql>flush  privileges;

mysql>use xxxDB; 

mysql> source /home/username/test.sql;

 

[4]

[w@wb ~]$ mysql -h 远程数据库主机IP -u 用户名 -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 28

Server version: 5.5.34 MySQL Community Server (GPL)

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use test;

Database changed

mysql>  show tables;

 

==========================

 mysql编译安装在centos6.5上；

==========================

# cd /opt/data/src/about_MySQL

# pwd

/opt/data/src/about_MySQL

# ll

total 301656

-rw-rw-r--. 1 tomcat tomcat 124769996 Aug 7 16:54 mysql-5.1.48-linux-x86_64-icc-glibc23.tar.gz

-rw-rw-r--. 1 tomcat tomcat 184122460 Aug 7 17:45 mysql-5.5.35-linux2.6-x86_64.tar.gz

# yum -y install ntp vim-enhanced gcc gcc-c++ flex bison autoconf automake bzip2-devel ncurses-devel zlib-devel libjpeg-devel libpng-devel libtiff-devel freetype-devel libXpm-devel gettext-devel pam-devel libtool libtool-ltdl openssl openssl-devel fontconfig-devel libxml2-devel curl-devel libicu libicu-devel libmcrypt libmcrypt-devel libmhash libmhash-devel

# wget https://distfiles.macports.org/cmake/cmake-2.8.12.tar.gz

# tar -xvzf cmake-2.8.12.tar.gz

# cd cmake-2.8.12

# ./configure

-- Check size of unsigned short

-- Check size of unsigned short - done

-- Using unsigned short

-- Check if the system is big endian - little endian

-- Looking for wsyncup in /usr/lib64/libcurses.so

-- Looking for wsyncup in /usr/lib64/libcurses.so - found

-- Looking for elf.h

-- Looking for elf.h - found

-- Looking for a Fortran compiler

-- Looking for a Fortran compiler - /usr/bin/f95

-- Looking for Q_WS_X11

-- Looking for Q_WS_X11 - found

-- Looking for Q_WS_WIN

-- Looking for Q_WS_WIN - not found

-- Looking for Q_WS_QWS

-- Looking for Q_WS_QWS - not found

-- Looking for Q_WS_MAC

-- Looking for Q_WS_MAC - not found

-- Found Qt4: /usr/bin/qmake-qt4 (found version "4.6.2")

-- Performing Test QT4_WORKS

-- Performing Test QT4_WORKS - Success

-- Performing Test run_pic_test

-- Performing Test run_pic_test - Success

-- Configuring done

-- Generating done

-- Build files have been written to: /opt/data/src/about_MySQL/cmake-2.8.12

---------------------------------------------

#make

#make install

-- Installing: /usr/local/share/cmake-2.8/completions/cmake

-- Installing: /usr/local/share/cmake-2.8/completions/cpack

-- Installing: /usr/local/share/cmake-2.8/completions/ctest

# mkdir -p /opt/myslqDatafile

# groupadd mysql

# useradd -s /sbin/nologin -M -g mysql mysql

# chown -Rv mysql:mysql /opt/myslqDatafile

changed ownership of `/opt/myslqDatafile' to mysql:mysql

# tar -xvzf mysql-5.5.35-linux2.6-x86_64.tar.gz

# cd mysql-5.5.35-linux2.6-x86_64

# pwd

/opt/data/src/about_MySQL/mysql-5.5.35-linux2.6-x86_64

#cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/opt/myslqDatafile -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_unicode_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_DEBUG=0

[root@product08-fastfile mysql-5.5.35-linux2.6-x86_64]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/opt/myslqDatafile -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_unicode_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_DEBUG=0

CMake Error: The source directory "/opt/data/src/about_MySQL/mysql-5.5.35-linux2.6-x86_64" does not appear to contain CMakeLists.txt.

Specify --help for usage, or press the help button on the CMake GUI.

报错，说是版本不对：

在这里https://downloads.skysql.com/archive/index/p/mysql/v/5.5.35

拉到页面最下方，找到Source Code

下载地址：https://downloads.skysql.com/archives/mysql-5.5/mysql-5.5.35.tar.gz

# cd /opt/data/src/about_MySQL/

# wget https://downloads.skysql.com/archives/mysql-5.5/mysql-5.5.35.tar.gz

--2014-08-11 13:44:03-- https://downloads.skysql.com/archives/mysql-5.5/mysql-5.5.35.tar.gz

Resolving downloads.skysql.com... 46.105.96.115, 2001:41d0:2:cf73::1

Connecting to downloads.skysql.com|46.105.96.115|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 21707804 (21M) [application/octet-stream]

Saving to: “mysql-5.5.35.tar.gz”

16% [==============> ] 3,686,171 861K/s eta 39s

# cd mysql-5.5.35

# pwd

/opt/data/src/about_MySQL/mysql-5.5.35

继续：

#cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/opt/myslqDatafile -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_unicode_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_DEBUG=0

-- Found Curses: /usr/lib64/libcurses.so

-- Looking for tputs in /usr/lib64/libcurses.so

-- Looking for tputs in /usr/lib64/libcurses.so - found

-- Looking for include file libaio.h

-- Looking for include file libaio.h - not found

-- Looking for io_queue_init in aio

-- Looking for io_queue_init in aio - not found

-- Performing Test HAVE_IB_GCC_ATOMIC_BUILTINS

-- Performing Test HAVE_IB_GCC_ATOMIC_BUILTINS - Success

-- Performing Test HAVE_IB_ATOMIC_PTHREAD_T_GCC

-- Performing Test HAVE_IB_ATOMIC_PTHREAD_T_GCC - Success

-- Check size of pthread_t

-- Check size of pthread_t - done

-- Performing Test HAVE_PEERCRED

-- Performing Test HAVE_PEERCRED - Success

-- Configuring done

-- Generating done

-- Build files have been written to: /opt/data/src/about_MySQL/mysql-5.5.35

#make

[100%] Building CXX object mysql-test/lib/My/SafeProcess/CMakeFiles/my_safe_process.dir/safe_process.cc.o

Linking CXX executable my_safe_process

[100%] Built target my_safe_process

# make install

-- Installing: /usr/local/mysql/man/man1/mysqlbug.1

-- Installing: /usr/local/mysql/man/man8/mysqld.8

-- Installing: /usr/local/mysql/support-files/solaris/postinstall-solaris

# cp ./support-files/my-medium.cnf /etc/my.cnf

# chown -Rv mysql:mysql /usr/local/mysql/

# cd /opt/data/src/about_MySQL/mysql-5.5.35

# pwd

/opt/data/src/about_MySQL/mysql-5.5.35

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

# ll /etc/init.d/mysqld

-rw-r--r--. 1 root root 10877 Aug 11 14:49 /etc/init.d/mysqld

# chmod +x /etc/init.d/mysqld

# ll /etc/init.d/mysqld

-rwxr-xr-x. 1 root root 10877 Aug 11 14:49 /etc/init.d/mysqld

# chkconfig mysqld on

# ln -sv /usr/local/mysql/bin/mysqladmin /usr/sbin/mysqladmin

`/usr/sbin/mysqladmin' -> `/usr/local/mysql/bin/mysqladmin'

# ln -sv /usr/local/mysql/bin/mysql /usr/sbin/mysql

`/usr/sbin/mysql' -> `/usr/local/mysql/bin/mysql'

# ln -sv /usr/local/mysql/bin/mysqldump /usr/sbin/mysqldump

`/usr/sbin/mysqldump' -> `/usr/local/mysql/bin/mysqldump'

#vi /etc/my.cnf

在[mysqld]段添加：

basedir = /usr/local/mysql

datadir = /opt/myslqDatafile

tmpdir = /tmp

尝试启动：

#/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/opt/myslqDatafile

# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/opt/myslqDatafile

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:

/usr/local/mysql//bin/mysqladmin -u root password 'new-password'

/usr/local/mysql//bin/mysqladmin -u root -h product08-fastfile password 'new-password'

Alternatively you can run:

/usr/local/mysql//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 /usr/local/mysql/ ; /usr/local/mysql//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd /usr/local/mysql//mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/local/mysql//scripts/mysqlbug script!

#/etc/init.d/mysqld start

# /etc/init.d/mysqld start

Starting MySQL.....[ OK ]

# netstat -nlp|grep mysqld

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 31641/mysqld

unix 2 [ ACC ] STREAM LISTENING 769067 31641/mysqld /tmp/mysql.sock

# ps aux|grep mysqld

root 31338 0.0 0.0 106224 1400 pts/3 S 14:59 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/opt/myslqDatafile --pid-file=/opt/myslqDatafile/product08-fastfile.pid

mysql 31641 0.3 0.1 772900 45172 pts/3 Sl 14:59 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/opt/myslqDatafile --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/opt/myslqDatafile/product08-fastfile.err --pid-file=/opt/myslqDatafile/product08-fastfile.pid --socket=/tmp/mysql.sock --port=3306

命令行管理，进入控制台：

# /usr/local/mysql/bin/mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.5.35-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

默认密码为空。

设置管理密码：

/usr/local/mysql/bin/mysqladmin password -uroot '123456'