Install and configure MySQL 5
with MacPorts
I decided to move my MySQL server installation from the server I
installed from MySQL.com to macports. Why? I believe MacPorts will
simplify future upgrades. I'd also like to keep my LAMP installs in the
same location. If you haven't already, install
and configure MacPorts
. Here are the steps I'll go over:
- Intall MySQL 5
- Create the initial MySQL databases
- Options for starting MySQL
- Confirm that MySQL is running
- Set Basic MySQL Security
Install MySQL 5
You can install using Porticus, Port Authority, or from the command
line:
sudo port install mysql5 +server
The +server variant is required if you'll need to create a system
startup item for MySQL 5. You'll see plenty of output during the build
process and an activation message just before the installation
completes.
Create initial MySQL databases
MySQL databases are kept in /opt/local/var/db/mysql5/ and you'll
notice that this directory is empty. Run mysql_install_db to create the
mysql and test databases.
sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql
Password:
You should see output similar to the following:
nstalling 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:
/opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password'
/opt/local/lib/mysql5/bin/mysqladmin -u root -h MacBook.local password 'new-password'
Alternatively you can run:
/opt/local/lib/mysql5/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 /opt/local ; /opt/local/lib/mysql5/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /opt/local/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /opt/local/lib/mysql5/bin/mysqlbug script!
The latest information about MySQL is available at http://www.mysql.com/
Support MySQL by buying support/licenses from http://shop.mysql.com/
Options for starting MySQL
I personally don't want MySQL to start at system start up, I'll start
it manually when I need it. If you're energy conscious and set your Mac
to go to sleep you won't want to set mysqld to start at system boot
either. If, however, you need MySQL to always start at system boot
sudo
launchctl load -w
/Library/LaunchDaemons/org.macports.mysql5.plist
sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
Whether you install the startup item or not, it's handy to add
aliases to your profile to start and stop mysql from the command line.
Use your favorite text editor (vi, pico, emacs) to add aliases.
vi
~/.profile
or
vi
~/.bash_profile
Add the following:
alias mysqlstart= 'sudo /opt/local/bin/mysqld_safe5 &' alias mysqlstop= '/opt/local/bin/mysqladmin5 -u root -p shutdown'
Note: Notice the '5' at the end of mysqld_safe? MacPorts adds version
numbers at the end of executables to allow the installation of multiple
versions (i.e. MySQL 4 and 5). You'll need to add the version number at
the end of some of the executables you use, like mysqladmin5. Now
you're ready to start your MySQL server with:
mysqlstart
or, if you didn't create aliases
sudo
/opt/local
/share/mysql5/mysql/mysql.server
start
Confirm that MySQL is running
If MySQL's okay, you should see a server start confirmation message.
You can test to ensure that MySQL is running with (leave password empty
when prompted):
mysqladmin5
-u root -p ping
Enter password: mysqld is alive
or with
mysql5 -u
root -p Enter password:
Welcome to the MySQL monitor. Commands end
with ; or \g. Your MySQL connection id
is 2
to server version: 5.0
.45
Type 'help;'
or '\h
'
for
help
. Type '\c
'
to clear
the buffer.
If you get the following error...
ERROR 2002
(
HY000)
: Can't connect to local MySQL server through socket '
/tmp/mysql.sock' (2)
...set the mysqld_safe socket path in a new MySQL configuration file.
Create /opt/local/etc/mysql5/my.cnf, add the following to it, save,
the try again.
[
mysqld_safe]
socket =
/tmp/mysql.sock
NOTE: If you've installed MacPort's PHP 5 you will probably need to
tell PHP where the MySQL socket is. Edit your php.ini file located at
/opt/local/etc/php.ini.
mysql.default_socket = /tmp/mysql.sock
Set Basic MySQL Security
Finally, set the root mysql password to secure your server.
mysqladmin5
-u root password
Moving MySQL data from other installations
If, like me, you want to move data from a previous MySQL 5 install
(i.e. /usr/local/mysql/data), be sure to stop MySQL first. You'll want
to overwrite the mysql database you created after installation when
copying over data files and indices. Ensure that everything copied to
/opt/local/var/db/mysql5/ remains owned by mysql. Refer to the MySQL
documentation if you're upgrading from MySQL 4 to 5.
Now get busy querying.
分享到:
相关推荐
《VMware vSphere: Install, Configure, Manage v5.1》是面向IT专业人员的高级培训资料,旨在帮助用户深入了解并掌握VMware vSphere 5.1的核心功能和技术要点。本书不仅适用于希望获得VMware Certified Professional...
VMware vSphere:Install,Configure,Manage vcp有实验手册-VSICM7-LAB-IE VMware vSphere:Install,Configure,Manage vcp有实验手册-VSICM7-LAB-IE
vmware-vsphere-install-configure-manage-v70
VMware vSphere Install Configure Manage V6.5_lab manual
《VMware vSphere 5 安装配置管理》是VMware公司推出的官方培训文档,针对的是VCP510认证考试。此文档详尽地介绍了虚拟化技术的基础以及VMware vSphere 5的核心功能和使用方法,对于学习和掌握虚拟化环境的管理和...
原厂培训材料, 12 PPTX ...You must know how to install and configure VMware ESXi™ hosts and VMware vCenter Server™. You must also know how to manage ESXi hosts and virtual machines with vCenter Server.
Install and configure your MySQL 8 instance without any hassle Get to grips with new features of MySQL 8 like CTE, Window functions and many more Perform backup tasks, recover data and set up various ...
MySQL 5.5版本开始,其源码安装过程引入了CMake作为新的构建系统,替代了传统的configure工具。这一变化使得构建过程更加现代化和灵活,同时也带来了一些转换上的注意事项。 首先,清理旧的构建文件是必要的,这...
programming languages, install and configure a Linux environment, and work with computer vision. Everything else you do with robots will be an extension of the lessons learned in this book.
VMware NSX Install, Configure, Manage [V6.2] Student Lab Manual
VMware_vSphere:Install、Configure、Manager_14_InstallvSphereComponents
VMware_vSphere:Install、Configure、Manager_06_Storage
The book teaches the reader to install, configure and set up the PHP scripting language, the MySQL database system, and the Apache Web server. By the end of this book the reader will understand how ...
记录相关的配置和安装_linux-install-and-configure
./configure --prefix=/usr/local/mysql --with-charset=gbk \ --with-collation=gbk_chinese_ci --with-extra-charsets=all --with-plugins=all ``` 3. **编译安装**: ```bash make make install ``` ####...
Over 130 task oriented recipes to install configure and manage various vSphere 5 1 components Overview Install and configure vSphere 5 1 core components Learn important aspects of vSphere such as ...