How to install MySQ Server 6.0 in Ubuntu 10.04 LTS Desktop?
(All commands need root user privilege of Ubuntu)
1. Download "mysql-6.0.11-alpha-linux-i686-glibc23.tar.gz" from MySQL website.
2. tar -zxvf mysql-6.0.11-alpha-linux-i686-glibc23.tar.gz
3. Rename it: mv mysql-6.0.11-alpha-linux-i686-glibc23.tar.gz mysql
4. Copy mysql folder to "/usr/local/mysql": cp -r mysql /usr/local/mysql
5. Change mode of mysql: chmod -R 777 mysql
6. Copy "my-small.cnf" to "/etc/my.cnf":
# cd /usr/local/mysql/support-files
# cp my-small.cnf /etc/my.cnf
7. Configure my.cnf (Red font text is updated; Green is added):
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock (Update it to this sock file if its position is changed.
Actually you need find this file - find / -name mysql.sock, and put down its name here.)
No bind-address to have remote client (MySQL-Front) access this MySQL server
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
user=root [color=gray]Add root user)
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data[/color]
port = 3306
socket = /tmp/mysql.sock Update it to this sock file if its position is changed.)
skip-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id = 1
# Uncomment the following if you want to log updates
#log-bin=mysql-bin
# binary logging format - mixed recommended
#binlog_format=mixed
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
8. Go to "/usr/mysql/" and run "scripts/mysql_install_db", NOTE: If you go to scripts and run "mysql_install_db", you'll get a message that this command is in "mysql-5.1-server, mysql-5.1-core-server and mysql-5.1-client package". So if you go to scripts folder, you have to type "./mysql_install_db". This will avoid confusion of your Ubuntu:
# cd /usr/mysql/scripts/
# ./mysql_install_db
By this way, maybe you won't set root password successfully, just try the following approaches:
Approach 1:
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 xavier-desktop (your machine name or localhost) password 'new-password'
Approach 2 (Even though you've run the "mysql_install_db" command):
Alternatively you can run:
/usr/local/mysql/bin/mysql_secure_installation
To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system. Definitely some variables need updating. Here I don't recommend you to have your mysqld started at boot time. Later, I will tell you how to start and stop MySQL Server.
How to STARTUP and SHUTDOWN mysql server 6.0
SHUTDOWN: # /usr/local/mysql/bin/mysqladmin -uroot -p shutdown
-u username
-p password
-h hostname
-P port
If you still cannot shutdown it, just kill the process.
# ps -aux|grep mysql
# kill -9 MySQL's PID
STARTUP: # /usr/local/mysql/bin/mysqld
FAQ of MYSQL 6.0 in UBUNTU 10.04 LTS DESKTOP
1. How to login MySQL
# /usr/local/mysql/bin/mysql -uroot -p (database)
2. How to change user's password
Approach 1:
mysql>use mysql
mysql>update user set password=password(“xavier”) where user=”root”;
mysql>flush privileges;
Approach 2:
Format: mysqladmin -uUSERNAME -pOLD_PASSWORD password NEW_PASSWORD
#mysqladmin -uroot -password xavier
Note: If password of root is empty, -p OLD_PASSWORD can be neglected.
3. How to connect MySQL through TCP, not local sock
In your machine, make sure you have install MySQL Client. When you trying to connect Remote MySQL Server(Make sure that you have start up your MySQL in your machine):
mysql -h remote-MySQL-Server-IP -u remote-MySQL-Server-IP-Username -p (This command can be typed in Win CMD or Linux Terminal Console)
4. How to Connect MySQL with MyEclipse?
Download MySQL Connector/J from MySQL website – format is tar.gz, unzip it and configure DB Explorer in MyEclipse by using this jar.
表名不区分大小写
1.用ROOT登录,修改/etc/my.cnf
2.在[mysqld]下加入一行:lower_case_table_names=1
分享到:
相关推荐
Ubuntu_10.04 安装、配置、指南
Ubuntu10.04下C连接mysql数据库.docx
Ubuntu10.04下C连接mysql数据库[参考].pdf
1、安装ubuntu server 10.04或10.10,其中安装语言选的en,时区shanghai,服务只安装ssh,其他全部用默认就行。 提示:以上安装过程完成后,建议用其他计算机登录服务器,windows系统可以用putty,linux系统直接在...
Ubuntu 10.04以上 属性 这些属性位于node['mysql_connector']['j']命名空间下。 属性 描述 类型 默认 校验和 适用于MySQL Connector / J的SHA256校验和 细绳 自动检测到或将记录警告 install_paths MySQL ...
环境:mysql 5 ubuntu10.04 x86_64 mdb1 eth0 192.168.5.11 mdb2 eth0 192.168.5.12 sdb1 eth0 192.168.5.21 sdb2 eth0 192.168.5.22 sdb3 eth0 192.168.5.23 sdb4 eth0 192.168.5.24 haproxy eth0 192.168.5.10 ...
Ubuntu 10.04-12.04 属性 用法 在提供管理服务器和 MySQL 服务器的节点上,同时使用 mgmd 和 mysqld 配方: { "run_list": ["recipe[btsync::install]", "recipe[btsync::ndb]" } 这将安装 btsync,并启动一个...
Ubuntu 10.04 x32/64(损坏的 postgresql 和 php5-fpm 池) Ubuntu 12.04 x32/64 - 推荐Ubuntu 13.04 x32/64 Debian 7.0 x32/x64(损坏的 postgresql) environment.yml安装 vim、mc、htop、git、php5-fpm、nginx、...
配置PHP以及MySQL的过程略去,如果在Ubuntu下,参考 Ubuntu 10.04 Installation Memo 即可。 1. 基本语法 要在HTML代码中嵌入PHP脚本的方法是在<?php ?>中书写代码。向浏览器输出数据采用echo或者print函数。...
平台此菜谱已经测试了以下平台,这意味着配方可以在这些平台上运行而不会出现错误: ubuntu(10.04 / 12.04) 请报告任何其他平台,以便可以添加它们。 食谱该食谱取决于以下外部食谱: 数据库(Opscode) ...
在 Ubuntu 系统上安装和配置 Graylog2 服务器(目前仅 10.04)。 这是针对 Graylog2 的 Sean Porter (@portertech) Linode StackScript 的 Chef 重新设计,可在此处获得: ://is.gd/cWA0w9 食谱 默认 下载、安装、...