多多色-多人伦交性欧美在线观看-多人伦精品一区二区三区视频-多色视频-免费黄色视屏网站-免费黄色在线

國內(nèi)最全IT社區(qū)平臺 聯(lián)系我們 | 收藏本站
阿里云優(yōu)惠2
您當前位置:首頁 > 數(shù)據(jù)庫 > 數(shù)據(jù)庫應用 > Mac下如何玩MySQL Server

Mac下如何玩MySQL Server

來源:程序員人生   發(fā)布時間:2015-05-07 09:21:30 閱讀次數(shù):3758次

最近弄事務相干的語句,開始弄select for update了,在ECS上做實驗,發(fā)現(xiàn)我安裝的版本只支持MyISAM,不支持InnoDB,事務沒法玩。因而在Mac上安裝了1份MySQL Server。

如何安裝,如何玩轉(zhuǎn),看說明書是最好的~

我的機器上,StartupItems安裝失敗了,也不知道為何。不過,MySQL Server安裝是成功的,所以采取手動模式啟動就OK了。


     shell> cd /usr/local/mysql
     shell> sudo ./bin/mysqld_safe
     (ENTER YOUR PASSWORD, IF NECESSARY)
     (PRESS CONTROL-Z)
     shell> bg
     (PRESS CONTROL-D OR ENTER "EXIT" TO EXIT THE SHELL)


You should be able to connect to the MySQL server, for example, by
running `/usr/local/mysql/bin/mysql'.



mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                        | Transactions | XA   | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| CSV        | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| FEDERATED  | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| ARCHIVE    | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         | NO           | NO   | NO         |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+

8 rows in set (0.00 sec)


可以看到支持InnoDB


然后就能夠開始玩起來啦~~


2.4.10 Installing MySQL on Mac OS X

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


You can install MySQL on Mac OS X 10.3.x (`Panther') or newer using a
Mac OS X binary package in PKG format instead of the binary tarball
distribution. Please note that older versions of Mac OS X (for example,
10.1.x or 10.2.x) are *not* supported by this package.


The package is located inside a disk image (`.dmg') file that you first
need to mount by double-clicking its icon in the Finder. It should then
mount the image and display its contents.


To obtain MySQL, see *Note getting-mysql::.


*Note*: Before proceeding with the installation, be sure to shut down
all running MySQL server instances by either using the MySQL Manager
Application (on Mac OS X Server) or via `mysqladmin shutdown' on the
command line.


To actually install the MySQL PKG file, double-click on the package
icon. This launches the Mac OS X Package Installer, which guides you
through the installation of MySQL.


Due to a bug in the Mac OS X package installer, you may see this error
message in the destination disk selection dialog:


     You cannot install this software on this disk. (null)


If this error occurs, simply click the `Go Back' button once to return
to the previous screen. Then click `Continue' to advance to the
destination disk selection again, and you should be able to choose the
destination disk correctly. We have reported this bug to Apple and it is
investigating this problem.


The Mac OS X PKG of MySQL installs itself into
`/usr/local/mysql-VERSION' and also installs a symbolic link,
`/usr/local/mysql', that points to the new location. If a directory
named `/usr/local/mysql' exists, it is renamed to
`/usr/local/mysql.bak' first. Additionally, the installer creates the
grant tables in the `mysql' database by executing `mysql_install_db'.


The installation layout is similar to that of a `tar' file binary
distribution; all MySQL binaries are located in the directory
`/usr/local/mysql/bin'. The MySQL socket file is created as
`/tmp/mysql.sock' by default. See *Note installation-layouts::.


MySQL installation requires a Mac OS X user account named `mysql'. A
user account with this name should exist by default on Mac OS X 10.2
and up.


If you are running Mac OS X Server, a version of MySQL should already
be installed. The following table shows the versions of MySQL that ship
with Mac OS X Server versions.


*Mac OS X Server       *MySQL Version*
Version*               
10.2⑴0.2.2            3.23.51
10.2.3⑴0.2.6          3.23.53
10.3                   4.0.14
10.3.2                 4.0.16
10.4.0                 4.1.10a


This manual section covers the installation of the official MySQL Mac
OS X PKG only. Make sure to read Apple's help information about
installing MySQL: Run the `Help View' application, select `Mac OS X
Server' help, do a search for `MySQL,' and read the item entitled
`Installing MySQL.'


For preinstalled versions of MySQL on Mac OS X Server, note especially
that you should start `mysqld' with `safe_mysqld' instead of
`mysqld_safe' if MySQL is older than version 4.0.


If you previously used Marc Liyanage's MySQL packages for Mac OS X from
`http://www.entropy.ch', you can simply follow the update instructions
for packages using the binary installation layout as given on his pages.


If you are upgrading from Marc's 3.23.x versions or from the Mac OS X
Server version of MySQL to the official MySQL PKG, you also need to
convert the existing MySQL privilege tables to the current format,
because some new security privileges have been added. See *Note
mysql-upgrade::.


If you want MySQL to start automatically during system startup, you
also need to install the MySQL Startup Item. It is part of the Mac OS X
installation disk images as a separate installation package. Simply
double-click the `MySQLStartupItem.pkg' icon and follow the
instructions to install it. The Startup Item need be installed only
once. There is no need to install it each time you upgrade the MySQL
package later.


The Startup Item for MySQL is installed into
`/Library/StartupItems/MySQLCOM'. (Before MySQL 4.1.2, the location was
`/Library/StartupItems/MySQL', but that collided with the MySQL Startup
Item installed by Mac OS X Server.) Startup Item installation adds a
variable `MYSQLCOM=-YES-' to the system configuration file
`/etc/hostconfig'. If you want to disable the automatic startup of
MySQL, simply change this variable to `MYSQLCOM=-NO-'.


On Mac OS X Server, the default MySQL installation bundled with the
operating system uses the variable `MYSQL' in the `/etc/hostconfig'
file. The Sun Microsystems, Inc. "Startup Item" installer disables
this variable by setting it to `MYSQL=-NO-'. This avoids boot time
conflicts with the `MYSQLCOM' variable used by the Sun Microsystems,
Inc. "Startup Item". However, it does not shut down a running MySQL
server. You should do that yourself.


After the installation, you can start up MySQL by running the following
commands in a terminal window. You must have administrator privileges
to perform this task.


If you have installed the Startup Item, use this command:


     shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
     (ENTER YOUR PASSWORD, IF NECESSARY)
     (PRESS CONTROL-D OR ENTER "EXIT" TO EXIT THE SHELL)


If you don't use the Startup Item, enter the following command sequence:


     shell> cd /usr/local/mysql
     shell> sudo ./bin/mysqld_safe
     (ENTER YOUR PASSWORD, IF NECESSARY)
     (PRESS CONTROL-Z)
     shell> bg
     (PRESS CONTROL-D OR ENTER "EXIT" TO EXIT THE SHELL)


You should be able to connect to the MySQL server, for example, by
running `/usr/local/mysql/bin/mysql'.


*Note*: The accounts that are listed in the MySQL grant tables
initially have no passwords.  After starting the server, you should set
up passwords for them using the instructions in *Note
post-installation::.


You might want to add aliases to your shell's resource file to make it
easier to access commonly used programs such as `mysql' and
`mysqladmin' from the command line. The syntax for `bash' is:


     alias mysql=/usr/local/mysql/bin/mysql
     alias mysqladmin=/usr/local/mysql/bin/mysqladmin


For `tcsh', use:


     alias mysql /usr/local/mysql/bin/mysql
     alias mysqladmin /usr/local/mysql/bin/mysqladmin


Even better, add `/usr/local/mysql/bin' to your `PATH' environment
variable. You can do this by modifying the appropriate startup file for
your shell. For more information, see *Note invoking-programs::.


If you are upgrading an existing installation, note that installing a
new MySQL PKG does not remove the directory of an older installation.
Unfortunately, the Mac OS X Installer does not yet offer the
functionality required to properly upgrade previously installed
packages.


To use your existing databases with the new installation, you'll need
to copy the contents of the old data directory to the new data
directory. Make sure that neither the old server nor the new one is
running when you do this. After you have copied over the MySQL database
files from the previous installation and have successfully started the
new server, you should consider removing the old installation files to
save disk space. Additionally, you should also remove older versions of
the Package Receipt directories located in
`/Library/Receipts/mysql-VERSION.pkg'.

生活不易,碼農(nóng)辛苦
如果您覺得本網(wǎng)站對您的學習有所幫助,可以手機掃描二維碼進行捐贈
程序員人生
------分隔線----------------------------
分享到:
------分隔線----------------------------
關(guān)閉
程序員人生
主站蜘蛛池模板: 国内久久精品视频 | 波多野结衣免费在线视频 | 欧洲爱爱 | jizz妇女 | 亚洲国产人成在线观看 | 免费国产成人α片 | 国产成人免费视频精品一区二区 | 国产成人亚洲毛片 | 哪里可以看免费毛片 | 国产欧美成人免费观看视频 | 综合久久久久久 | 中文字幕日产乱码 | 精品视频中文字幕 | 日本高清在线观看视频www | 国产精品久久毛片 | a毛片全部播放免费视频完整18 | 国产精品视频国产永久视频 | 天天亚洲综合 | 亚洲成综合人影院在院播放 | 欧美xxxx喷潮| 国产精品一页 | 爱爱日韩 | 久久一级视频 | 国产1区2区三区不卡 | 成年人免费网站视频 | 久久久久久久国产精品 | 精品国产综合成人亚洲区 | 午夜dj免费视频观看社区 | 三级视频网 | 欧美日韩在线看 | 日韩理论片在线看免费观看 | 看片亚洲 | 午夜视频免费看 | 免费一级毛片在播放视频 | 国产的一级毛片完整 | 欧美日韩乱国产 | 国产女人的一级毛片视频 | 精品一区二区三区在线视频观看 | 精品的一区二区三区 | 色综合美国色农夫网 | 一级爱爱片一级毛片-一毛 一级爱一级做a性视频 |