甲骨虫的家

mysql 执行脚本的方法 mysql>source file_name 或： mysql> \. file_name 而oracle中执行脚本 sql>@file_name

#!/bin/bash ### MySQL Server Login Info ### MUSER="root" MPASS="root" MHOST="localhost" MYSQL="$(which mysql)" MYSQLDUMP="$(which mysqldump)" DBNAME="test" BAK="/backup/mysql" GZIP="$(which g

1.停掉mysql服务 2.打开一个命令行窗口用如下命令启动mysql mysqld --skip-grant-tables 3.修改root密码 另外打开一个命令行窗口执行下面命令 mysql mysql> use mysql mysql> update user set password=password('new_password') where user='r

1. Download http://dev.mysql.com/downloads/mysql/#downloads 2. upload it to linux server and unzip it tar -zxvf packagename 3. create user and usergroup mkdir -p /opt/mysql gro