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 安装与配置详尽指南 #### 一、准备工作 在正式开始安装之前,确保已经完成了以下准备工作: 1. **下载 Ubuntu 镜像文件**: - 访问官方链接或其他可靠的源,下载 Ubuntu 10.04 LTS 的 ISO 镜像...
在Ubuntu 10.04操作系统中,C语言连接MySQL数据库涉及多个步骤,包括安装必要的软件包、配置MySQL服务以及编写C程序进行连接。以下是详细的知识点解释: 1. **安装MySQL服务器和客户端**: 要在Ubuntu 10.04上安装...
在Ubuntu 10.04操作系统中,C语言连接MySQL数据库是一个常见的需求,这涉及到一系列的配置和安装步骤。以下是一些关键知识点的详细说明: 1. **安装MySQL服务器**: - 安装`mysql-server-5.1`:在Ubuntu 10.04上,...
首先,搭建LAMP平台之前,需要准备一台安装了Ubuntu 10.04的计算机,或使用虚拟机软件(如VMware)来创建一个虚拟机,其中操作系统选择Ubuntu 10.04。Ubuntu系统的网络设置应采用NAT方式,这样能够通过设置静态IP,...
### Ubuntu 10.04 LTS 下 Nagios 3.4.1 的简单安装与配置 #### 一、概述 本文档将详细介绍如何在 Ubuntu 10.04 LTS 系统上安装并配置 Nagios 3.4.1 监控系统。Nagios 是一款开源的网络监控工具,能够帮助管理员对...
1. **添加MySQL存储库**:在Ubuntu 10.04上,可以使用`apt-get install`命令安装MySQL,但需要先添加官方的MySQL存储库。 2. **安装MySQL**:执行`sudo apt-get update`更新包列表,然后运行`sudo apt-get install ...
3. **MySQL安装与管理**: 这部分会介绍如何安装MySQL,创建root用户,设置密码,以及如何通过命令行工具或图形界面管理数据库。 4. **PHP安装与测试**: 安装PHP后,文档可能会指导如何创建一个简单的PHP测试页面,...
《Ubuntu 10.04中文手册》是针对Ubuntu Linux操作系统的一个详尽指南,特别针对中文用户设计。Ubuntu是一款基于Debian的开源操作系统,深受全球技术爱好者和开发者的喜爱。这个CHM(Microsoft Compiled HTML Help)...
本篇文章将详细讲解如何在Ubuntu 10.04上安装Apache、PHP和MySQL。 首先,我们开始安装Apache。Apache HTTP Server是世界上最流行的Web服务器软件,用于提供静态和动态内容。在Ubuntu中,我们可以使用apt-get命令来...
在软件方面,Ubuntu 10.04提供了丰富的应用商店——Ubuntu Software Center,用户可以方便地浏览、安装和管理各类软件。这个版本预装了Firefox浏览器、Evolution邮件客户端、OpenOffice办公套件等常用工具,满足了...
在本文中,我们将深入探讨如何在Ubuntu 10.04系统中安装和配置MySQL数据库、FreeRADIUS认证服务器以及Java开发环境(JDK)。首先,确保你的系统已设置为英文编码并采用DHCP方式进行网络访问,这将有助于后续软件的...
在本文中,我们将指导您如何在 Ubuntu 10.04 环境下搭建 PHP 网站运行环境,包括安装 Ligd、PHP、MySQL 和 phpMyAdmin 等组件的详细步骤。 安装 Ligd Ligd 是一个轻量级的 Web 服务器,可以用来托管 PHP 网站。在 ...
【Ubuntu 10.04 LAMP Server 安装指南】 Ubuntu 10.04 LAMP Server 的安装过程是一个快速而简洁的操作,适合初学者和经验丰富的IT专业人士。LAMP 是 Linux、Apache、MySQL 和 PHP 的首字母缩写,它们共同构成了一个...