mysql

最新推荐文章于 2025-09-06 22:56:13 发布

weixin_33775582

最新推荐文章于 2025-09-06 22:56:13 发布

阅读量88

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 php

原文链接：http://www.cnblogs.com/qike/p/5277016.html

本文提供了一系列MySQL的基本操作指导，包括创建数据库、用户管理、权限设置、数据导入等实用命令。此外还介绍了如何解决常见的权限问题及如何修改root用户的密码。

mysql -u root -p
show databases;
create database test;
use test

show current user name:

SELECT CURRENT_USER();

set password for current user:
SET PASSWORD = PASSWORD(’123456’);

show all users:
SELECT User FROM mysql.user;

create a user with remote access:
mysql> CREATE USER ‘test’@‘localhost' IDENTIFIED BY ‘123456’;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'test'@'localhost'
-> WITH GRANT OPTION;
mysql> CREATE USER 'test'@'%' IDENTIFIED BY '123456';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'test'@'%'
-> WITH GRANT OPTION;

permission issue with the mysql folder: ERROR! MySQL server PID file could not be found!
sudo chmod -R 777 ./mysql/*

mysql
set mysql root password
/usr/local/mysql/bin/mysqladmin/ -u root password ‘yourpassword'
stop mysql
sudo /usr/local/mysql/support-files/mysql.server start

show database
show databases;

show tables
show tables from database;

select database
use database;

table structure
describe table;

table insert
insert into table (user, password) values ('test', 'test’);

change mysql root password in php admin
encoded password: 6BeC4xZEtDwAv7vF
no encoded password: 123456

creating a database
create database database_name;

creating a table
create table customers (name varchar(20), city varchar(20), country varchar(20));

load text file into table
LOAD DATA LOCAL INFILE ‘/path/pet.txt’ INTO TABLE pet;
or -> LINES TERMINATED BY ‘\r\n’; (OS X LINE TERMINATED BY ‘\r’)

add new records one at a time
mysql> INSERT INTO pet
-> VALUES (‘Puffball’, ‘Diane’, ‘hamster’, ‘f’, ‘1999-03-30’, ‘NULL’);

bypassing foreign key constraint
SET foreign_key_checks = 0; SET foreign_key_checks = 0;

转载于:https://www.cnblogs.com/qike/p/5277016.html