- 浏览: 828723 次
- 性别:
- 来自: 深圳
文章分类
- 全部博客 (379)
- struts (5)
- hibernate (16)
- spring (16)
- ssh (20)
- MySQL (16)
- 数据库脚本 (2)
- DownLoad (1)
- GAE (5)
- Java (103)
- LoadRunner (2)
- VF (1)
- 学习资料 (24)
- 软件使用 (21)
- 通信类 (4)
- 生活 (3)
- J2ME (1)
- 心理学 (1)
- Linux (26)
- Android (3)
- Oracle (1)
- 面向对象概念&面试准备 (11)
- ExtJs (2)
- Google Map (1)
- Flex (47)
- 算法研究 (1)
- share (20)
- python (1)
- MongoDB (7)
- centos6 (13)
- C++ (8)
- DB2 (3)
- C# (1)
- 代码片段 (24)
- Lucene (2)
- php (1)
- NodeJS (1)
- Express (1)
最新评论
-
shua1991:
已阅,我表示同意。
Eclipse统计代码行数 -
nakedou:
写的不错,挺详细的
在CentOS中使用 yum 安装MongoDB及服务器端配置 -
sjp524617477:
好方法
Eclipse统计代码行数 -
simpletrc:
<script>ale ...
Java写到.txt文件,如何实现换行 -
csdn_zuoqiang:
Apache Ftp Server,目前是1.0.4,非常好的 ...
Apache FtpServer在64位系统下服务不能启动解决方法
[root@www ~]# yum -y install mysql-server [root@www ~]# /etc/rc.d/init.d/mysqld start Initializing MySQL database: Installing 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: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h www.server.world password 'new-password' Alternatively you can run: /usr/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 /usr ; /usr/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd /usr/mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/bin/mysqlbug script! Starting mysqld: [ OK ] [root@www ~]# chkconfig mysqld on [root@www ~]# mysql -u root # connect to MySQL Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.52 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. # show user info mysql> select user,host,password from mysql.user; # set root password mysql> set password for root@localhost=password('password'); Query OK, 0 rows affected (0.00 sec) # set root password mysql> set password for root@'127.0.0.1'=password('password'); Query OK, 0 rows affected (0.00 sec) # set root password mysql> set password for root@'www.server.world'=password('password'); Query OK, 0 rows affected (0.00 sec) # delete anonymous user mysql> delete from mysql.user where user=''; Query OK, 2 rows affected (0.00 sec) mysql> select user,host,password from mysql.user; mysql> exit # quit Bye [root@www ~]# mysql -u root -p # connect with root Enter password:# MySQL root password Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.1.52 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> exit Bye
发表评论
-
mysql、sqlserver、oracle分页,java分页统一接口实现
2012-03-13 17:56 0定义: pageStart 起始页,pageEnd 终止页, ... -
DB2 9.7 64bit 在 CentOS5.4 64bit 上的安装
2011-09-02 17:57 3417都是安装的时候记的笔记了,应该能看懂。 1. downloa ... -
CentOS 5.5 防火墙开启、关闭以及开放指定端口
2011-09-01 10:34 1126服务器使用的是CentOS 5.5,部署好Tomcat之后却发 ... -
CentOS6下安装flashplayer
2011-08-25 14:34 991将解压后的libflashplayer.so文件复制到/usr ... -
如何删除 CentOS 6 更新后产生的多余的内核
2011-08-25 13:30 2412在CentOS 6更新后,不可避免的会在启动选项中产生多个 ... -
CentOS6挂载NTFS分区问题
2011-08-25 13:24 1804[zuoqiang@centos ~]$ su Pass ... -
CentOS6 下Eclipse C++ 开发环境配置
2011-08-24 23:46 10519在CentOS下安装Eclipse C++开发环境 ... -
centos6 install jdk-6u27-linux-x64.bin
2011-08-24 23:43 7645#java -version如有openjdk的东东要删除yu ... -
在ubuntu和centos下面安装fcitx
2011-08-22 16:35 3992为了改变启动顺序,想 ... -
vim配置文件(带详细中文注释)
2011-08-22 16:33 7039" 不要使用vi的键 ... -
7个Linux chkconfig命令实例
2011-08-22 16:32 864http://www.centos.bz/2011/07/7- ... -
[CentOS]Yum命令详解
2011-08-22 10:39 4012yum是什么 yum = Yellow dog ... -
[CentOS]压缩+解压+打包命令大全
2011-08-22 10:25 1387.tar 解包:tar xvf FileName.tar ... -
MYSQL性能优化【总结】
2011-08-16 16:43 13031、分库分表 很明显,一个主表(也就是很重要的表,例 ... -
Installing MongoDB 1.8.1 on Ubuntu 10.10 & 11.04 and running with an ‘init’ scri
2011-07-20 14:57 1191Installing MongoDB 1.8.1, in my ... -
mysql中创建外键的条件
2011-03-16 10:52 23961、外键的引用类型必须一致,如果主键是int外键是char则不 ... -
Web服务器性能/压力测试工具http_load、webbench、ab、Siege使用教程
2010-09-14 14:58 1182一、http_load 程序非常 ... -
MySQL整理
2010-09-08 22:59 15011. 备份 mysqldump -u roo ... -
SQL FOREIGN KEY 约束
2010-09-03 13:55 1237一个表中的 FOREIGN KEY 指向另一个表中的 PRIM ... -
MySQL DBA 职位要求
2010-08-12 14:48 2068职位描述 <!-- Job Desc Page ...
相关推荐
Explore the various means to install MySQL for Python, from using an egg to unrolling a tarball Query the database and retrieve records through MySQL for Python Implement insertion of data into a ...
dpkg: error processing package mysql-community-server (--install): dependency problems - leaving unconfigured Processing triggers for man-db (2.6.7.1-1ubuntu1) ... Processing triggers for ureadahead ...
PHP and MySQL in easy steps, 2nd edition begins by explaining how to install a free web server, the PHP interpreter, and MySQL database server, to create an environment in which you can produce your ...
Paul DuBois and his editors at New Riders have assembled MySQL with a clarity and lucidity that inspires confidence in the subject matter: a (nearly) freely redistributable SQL-interpreting database ...
1.3. Overview of the MySQL Database Management System 1.3.1. What is MySQL? 1.3.2. History of MySQL 1.3.3. The Main Features of MySQL 1.4. MySQL Development History 1.5. What Is New in MySQL 5.5 1.5.1...
./scripts/mysql_install_db --user=mysql /usr/local/mysql/bin/mysqld_safe --user=mysql & /usr/local/mysql/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL ...
It suppots such database as Oralce,MS SQLServer,MySQL,Access,SQLAnywhere and Sybase. Through the BDB you can quickly build up a database model and do two-way synchronization entities with the ...
It suppots such database as Oralce,MS SQLServer,MySQL,Access,SQLAnywhere and Sybase. Through the BDB you can quickly build up a database model and do two-way synchronization entities with the ...
Apache一起使用 MySQL 18 问题和常见的错误 18.1 如果 MySQL总是崩溃怎么办 18.2 使用 MySQL 时一些常见错误 18.2.1 MySQL server has gone away错误 18.2.2 Can't connect to [local] MySQL ...
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 ...
4.13 OS/2 注意事项 4.14 TcX 二进制代码 4.15 安装后期(post-installation)的设置与测试 4.15.1 运行mysql_install_db 的问题 4.15.2 启动 MySQL 服务器的问题 4.15.3 自动启动和停止...
数据库的基本操作 46 3.1 MYSQL的启动与终止 47 3.1.1 直接运行守护程序 47 3.1.2 使用脚本mysql.server启动关闭数据库 48 3.1.3 使用mysqladmin实用程序关闭、重启数据库 49 3.1.4 启动或停止NT平台...
+ 4.15.1 运行mysql_install_db 的问题 + 4.15.2 启动 MySQL 服务器的问题 + 4.15.3 自动启动和停止 MySQL + 4.15.4 选项文件 o 4.16 升级和降级(downgrading)时有什么特别要做的事情吗? + 4.16.1 从一个 ...
在root账户里安装mysql-server服务器:【yum -y install mysql-server】" " " " " "昨天 17:07 上传 " "下载附件 (113.47 KB) " " " " " " " " " " " "3.安装成功,看看吧,yum会自动安装与mysql-server软件包相关...
You need a MySQL database server (5.0+) and run the commands below through a user that has the following privileges: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, REFERENCES, INDEX, ALTER, ...
mysql > create database chatserver ; mysql > create user ' chat ' @ ' localhost ' identified by ' chat123 ' ; mysql > grant all privileges on chatserver. * to ' chat ' @ ' localhost ' ; mysql > exit ...
安装 $ sudo apt-get install python-setuptools $ sudo easy_install pip $ sudo pip install mysql-replication ...mysql > create database contact ; mysql > use contact ; mysql > create table contacti
10、在出现的配置界面中选择mysql数据库的用途,“Multifunctional Database(通用多功能型)”、“Transactional Database Only(服务器类型)”、“Non-Transactional Database Only(非事务处理型)”,这里我...
安装说明(以ubuntu14.04为例)1,安装LAMP环境sudo apt-get install lamp-server^2,安装python环境系统已经安装python2.7,需要安装mysql-python,采用pip进行安装sudo apt-get install python-pip python-devsudo...
毕业设计基于Opencv的车牌识别系统 1 实现功能 ...mysql.server start --skip-grant-tables mysql -uroot CREATE USER 'python'@'%' IDENTIFIED BY 'Python12345@'; CREATE database chepai; GRA