Reset Mysql Root Password in XAMPP 在XAMPP中重置MySql密码

Categories: Database; Tagged with: ; @ September 1st, 2010 21:15

默认情况下, 通过XAMPP安装的Mysql Root密码为空.

在XAMPP中重置Mysql密码:

1. Go to http://localhost:port/security/  该链接将会对目前的配置进行安全检查

2. 该页面会检查当前安全配置, 并会带有链接: http://localhost/security/xamppsecurity.php

3. 该页面中可进行重置密码等操作.

See more : http://veerasundar.com/blog/2009/01/how-to-change-the-root-password-for-mysql-in-xampp/

[旧]使用ERwin反向工程生成Oracle数据库的Physical Modal(物理数据模型)

Categories: Database; Tagged with: ; @ August 29th, 2010 18:22

=> 首先参考使用ERwin反向工程生成MySQL数据库的Physical Modal[物理数据模型]

选择Oracle, Next, 到如下界面:

Oracle

Connect, 稍等片刻即可.

MySql: backup and restore database using mysql/mysqldump

Categories: Database; Tagged with: ; @ July 31st, 2010 16:21

Backup database:

> (sudo) mysqldump db-name > db-backup.sql

Restore database:

> (sudo) mysql db-name (--no-date)(no-create-info) < db-backup.sql

MySql:#1467 – Failed to read auto-increment value from storage engine

Categories: Database; Tagged with: ; @ March 14th, 2010 23:31

某日, mySql(5.1.30-community)如此报错, 用phpMyAdmin强行插入, 亦是如此:

image

但如直接指定Auto-Increment的 Field, 就可顺利插入.

解决:

修改该自增Filed的属性, 先将其自增属性点掉:

image

保存后, 再点选其自增, 再保存, 问题暂时解决.

英文水平有限, 暂不深究….

使用MysqlWorkbench 生成mysql反向工程

Categories: Database; Tagged with: ; @ April 1st, 2009 14:44

首先将MySQL数据库导出, 可使用PhpMyAdmin等工具,

打开WorkBench, File > import > Reverse Enginner MySQL Create Script…

选择导出的mysql文件, 确定即可.

image

Newer Posts <-> Older Posts



// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.