mysql 管理员 root 密码 123456
初始化并启动:
1、以管理员身份运行cmd,在cmd中输入:mysqld --initialize-insecure --user=mysql ##以不设置密码方式初始化mysql
2、安装mysql:mysqld --install ##出现service successfuly installed,表示配置完成
3、启动数据库:net start mysql ##可能会碰到找不到vcruntime140.dll错误提示,此时需下载“微软常用运行库合集”并进行安装,很大概率可以解决此问题
4、登录数据库:mysql -u root -p ##回车后后提示输入密码,此时直接回车,不用理会
5、设置初始化密码:alter user user() identified by "初始密码"; ##回车,一定要以分号隔开
ALTER USER USER() IDENTIFIED BY '123456';
6、再次登录数据库,验收密码:mysql -u root -p ##回车后,输入第5步设置的初始密码,即可进入mysql>
7、配置完成,关闭数据库并即出:
输入:mysql>net stop mysql
mysql>quit
创建用户 create user 'zyzx'@'%' identified by 'zyzx';
创建db create database schooldb;
use schooldb;
create database schooldb DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
grant all privileges on schooldb.* to 'zyzx'@'%';
SHOW CREATE TABLE test_table;
show full columns from test1;
C:\Users\ycscs>mysql -u root -p
Enter password: ******
mysql> create user 'llks'@'%' identified by 'llks';
mysql> create database llksdb;
mysql> grant all privileges on llksdb.* to 'llks'@'%';
mysql> exit;
Bye
C:\Users\ycscs>mysql -u llks -p
mysql> use llksdb;
表中增加一列 alter table tbl_user_info add column address varchar(100);
mysql -u 用户名 -p
输入密码
create user 'llks'@'%' identified by 'llks';
create database llksdb;
grant all privileges on llksdb.* to 'llks'@'%';
flush privileges;
--------------------------------------oracle
String driverName="oracle.jdbc.driver.OracleDriver" ;
String url="jdbc:oracle:thin:@ip:1521:db" ;
String username="zyd";
String password="zyd";
public Connection getConnection(){
Connection connection=null;
try {
/*Class.forName(property.getProperty("driverName"));
String url=property.getProperty("url");
String username=property.getProperty("username");
String password=property.getProperty("password");*/
Class.forName(driverName);
connection=DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}