快速业务通道

linux 下 MySQL源码包的安装

作者 佚名技术 来源 Linux系统 浏览 发布时间 2012-05-03
n/mysqladmin -u root -h localhost.localdomain password ''new-password'' 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 the benchmarks in the ''sql-bench'' directory: cd sql-bench ; perl run-all-tests Please report any problems with the /usr/local/mysql/bin/mysqlbug script! The latest information about MySQL is available on the web at [url]http://www.mysql.com[/url] Support MySQL by buying support/licenses at [url]http://shop.mysql.com[/url] [root@localhost mysql]# [root@localhost mysql]# chown -R root . 改变当前目录的所有属主为root -R 为递归(即其下所有的子文件的属主也随之改为root) [root@localhost mysql]# chown -R mysql var 改变var的属主为mysql [root@localhost mysql]# chgrp -R mysql . 改变当前目录的属组为mysql [root@localhost mysql]# [root@localhost mysql]# bin/mysqld_safe --user=mysql & 后台启动mysql服务 &为后台启动 [1] 17776 [root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var [root@localhost mysql]# [root@localhost mysql]# /usr/local/mysql/bin/mysql 登陆到mysql数据库 Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 to server version: 4.0.27-log Type ''help;'' or ''h'' for help. Type ''c'' to clear the buffer. mysql> mysql> show databases ; 基本的查看数据库命令 ---------- | Database | ---------- | mysql | | test |---------- 2 rows in set (0.00 sec) mysql> mysql> ? 查询命令 For the complete MySQL Manual online visit: [url]http://www.mysql.com/documentation[/url] For info on technical support from MySQL developers visit: [url]http://www.mysql.com/support[/url] For info on MySQL books, utilities, consultants, etc. visit: [url]http://www.mysql.com/portal[/url] List of all MySQL commands: (Commands must appear first on line and end with '';'') help (h) Display this help. ? (?) Synonym for `help''. clear (c) Clear command. connect (r) Reconnect to the server. Optional arguments are db and host. edit (e) Edit command with $EDITOR. ego (G) Send command to mysql server, display result vertically. exit (q) Exit mysql. Same as quit. go (g) Send command to mysql server. nopager (n) Disable pager, print to stdout. notee (t) Don''t write into outfile. pager (P) Set PAGER [to_pager]. Print the query results via PAGER. print (p) Print current command. prompt (R) Change your mysql prompt. quit (q) Quit mysql. rehash (#) Rebuild completion hash. source (.) Execute a SQL script file. Takes a file name as an argument. status (s) Get status information from the server. system (!) Execute a system shell command. tee (T) Set outfile [to_outfile]. Append everything into given outfile. use (u) Use another database. Takes database name as argument. Connection id: 2 (Can be used with mysqladmin kill) mysql> quit Bye [root@localhost mysql]# 退出数据库

凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务,公司网站:http://www.lingzhong.cn 为了给广大客户了解更多的技术信息,本技术文章收集来源于网络,凌众科技尊重文章作者的版权,如果有涉及你的版权有必要删除你的文章,请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息,谢谢!

分享到: 更多

Copyright ©1999-2011 厦门凌众科技有限公司 厦门优通互联科技开发有限公司 All rights reserved

地址(ADD):厦门软件园二期望海路63号701E(东南融通旁) 邮编(ZIP):361008

电话:0592-5908028 传真:0592-5908039 咨询信箱:web@lingzhong.cn 咨询OICQ:173723134

《中华人民共和国增值电信业务经营许可证》闽B2-20100024  ICP备案:闽ICP备05037997号