MySQL users and privileges

A summary of the relevant command USE mysql UPDATE USER SET user='test' WHERE user = '' GRANT ALL ON *.* TO 'jerry'@'%' IDENTIFIED BY 'mypass' FLUSH PRIVIELEGES SELECT USER(); SHOW GRANTS Second, the summary of the practical problems 3.1 How to limit

ORACLE database simple migration

1 Export objects (tables, indexes, sequences, etc.) PLSQL-> TOOLS-> Export User Objects Note that the default for the SQL file 2 Exporting Data PLSQL-> TOOLS-> Export Tables Exporting objects with similar interfaces, note the default for

Change the MYSQL root password

First, select the mysql database as the default, then use the update command to update the password: mysql>use mysql; Database changed mysql>update user set password=PASSWORD('123456') where user='root'; Query OK, 0 rows affected (0.00 sec) Row

MySql linux related configuration

1, the character set to UTF8 Modify / etc / my.cnf (If not, under the my-medium.conf mysql copying to / etc, and change the name to, my.cnf) In the [client] and [mysqld] add default-character-set = utf8 You can restart the service 2, modify the MySQL

ubuntu configure multiple instances of mysql (Larry Xu Gang Original)

port, socket, pid-file, datadir these four parameters must be different, the rest can choose according to their own settings. [Configuration]: 1 copy datadir # Cp-r / var / lib / mysql / var/lib/mysql_3301 # Cp-r / var / lib / mysql / var/lib/mysql_3

CentOS yum install Apache + PHP + MySQL

1: Install MySQL 1 Installation yum install mysql mysql-server mysql-devel 2 Start the MySQL /etc/init.d/mysqld start 3 Set the initial password MySQL Assuming the password is set to 123 456 mysqladmin -u root password 123456 4 set to logon remotely

Ubuntu Open MySQL remote access function

Confirm whether the 3306 opening, MySQL default is not open external access function. See the following ways: netstat -an | grep 3306 Display the results :tcp 0 0* LISTEN As can be seen from the above, mysql is listening to po

mysql: ERROR 1045 (28000): Access denied for user

ERROR 1045 (28000): Access denied for user Generally need to apply IP access to DBA privileges!

Mysql connection with MysqlODBC error: Client does not support authentication protocol requested ...

Gorgeous split lines ------- --------------------------------------- ---------------------------------- Problem Description: mysql5.0 connection with mysqlodbc3.51: Can not access a "mysql" database system dsn. (Root account password is rig

[Summary] mysql common operation [grant, show]

1 Create an account with full privileges mysql>grant all privileges on *.* to User name @'localhost' identified by ' Password '; mysql>flush privileges; Recommended links to view details:

Some operating under Linux Mysql

1, Linux Mysql command to start: / Etc / init.d / mysql start 2, close the Mysql command: / Etc / init.d / mysql shutdown 3, restart the Mysql command: / Etc / init.d / mysql restart 4, create a user: grant privilege (all rights on behalf of all) on

MySQL Grammar of user rights

MySQL user permissions to give a simple command format can be summarized as: grant Permissions on database objects to User A, grant general data users, query, insert, update, delete data in all tables in the database right. grant select on testdb.* t

under linux mysql root password forgotten solution

1, close Mysql: If MySQL is running, the first kill killall-TERM mysqld 2, another way to start MySQL: bin / safe_mysqld - skip-grant-tables & 3, may not need a password to access the MySQL. Then is > Use mysql > Update user set password =

[Essence] [Share] chmod command usage details Author: sdccf at :2004 -01-09 10:42:16 Command name: chmod Access: All users use: chmod [-cfvR] [- help] [- version] mode file ... Description: Linux / Unix file permissions is called into three groups: the file owner, group,

MySQL root password to modify the method

Method 1: Use SET PASSWORD command mysql-u root mysql> SET PASSWORD FOR 'root' @ 'localhost' = PASSWORD ('newpass'); Method 2: using mysqladmin mysqladmin-u root password "newpass" If the root password has been se

Remote connection MYSQL prompt Host is not allowed to connect to this MySQL server problem-solving

If this happens when mysql connection error: ERROR 1130: Host '192 .168.1.3 'is not allowed to connect to this MySQL server 1. Change table method. Your account may be allowed from a remote landing, only localhost. This time as long as that c

Open the mysql client connection settings

When you use the linux client to connect the mysql database host, if you are not allowed to connect. The following settings, the client can connect properly. Must be modified in mysql Ie mysql> The following 'ServerIP' to interact with sys

PLSQL Developer questions - Dynamic performance Table not accessible

Use PLSQL Developer, has just entered, select a table ,-----> edit data One Tip: Dynamic performance Table not accessible Automatic Statistics disbled this seesion you can Statistics in the preference menu, obtain select priviliges on the V $ sess

mysql - operation create user failed

Issues: create a user in mysql (create user aa @ localhost identified by 'password'; flush privileges;) after, for some reason want to rebuild the user, the tiger looked under the mysql database tables directly delete from user where user =

MySQL Replace INTO advanced use

REPLACE and INSERT operation is very similar. Only one exception, if the table for an old record with a PRIMARY KEY or a UNIQUE index to a new record has the same value, before the new record is inserted, the old record is deleted. See Section 13.2.4

oracle start and stop services

To start or stop the service, you must have sysdba privileges. Are two ways you can use to connect: First, connect to sys user c: \> sqlplus sys / change_on_install as sysdba; Enter the sql * plus environment; (Note, ORACLE9I at the time of instal

Python development environment set up under Ubuntu

1 Installing MySQL $ sudo apt-get install mysql-server mysql-client After installation, MySQL will by default start in a terminal run the following command to view if MySQL is running $ sudo netstat -tag|grep mysql You can see the results similar to

add permissions for the current directory linux

add permissions for the current directory linux chmod 777 *.* Original: the linux chmod, chown command Detailed Source: ChinaUnix blog Date: 2007.12.11 09:48 (Total comment) I want to

How to change root password ubuntu

Some versions of Ubuntu are hidden super-user, but many places have to use the super-user privileges. We can set super user: ... ...: ~ $ Sudo passwd Password: -> enter that user's password during installation Enter new UNIX password: -> Ne

Improve the script with sudo privileges

Improve the script with sudo privileges First, why use sudo? sudo privileges can improve the script, for example: We have encountered this problem, Some files need to be removed by the web application, but they do not have permission to access apache

Forget MySQL Root Password

Forget MySQL Root Password 1. Stop the mysql service > / Etc / init.d / mysql stop 2. Start the server without password > Mysqld_safe - skip-grant-tables & 3. Connect to the mysql server > Mysql-u root 4. Setup new MYSQL root user passwo

MSSQL database users

1, create a login account (1) Add the Windows logon account EXEC sp_grantlogin 'jbtraining \ S26301' (domain name \ user name) (2) add a SQL login account EXEC sp_addlogin 'zhangsan', '1234 ' EXEC that calls stored procedures,

mysql reset permissions

Close mysql: # Service mysqld stop Then: # Mysqld_safe - skip-grant-tables Start mysql: # Service mysqld start mysql-u root mysql> use mysql mysql> UPDATE user SET Password = PASSWORD ('xxx') WHERE user = 'root'; mysql> flush

oracle table space to create the user to grant permission

--- Window system SYS user in the CMD, the DBA login: In the CMD in the fight sqlplus / nolog Then conn / as sysdba / / Create a temporary table space create temporary tablespace temporary table space name tempfile 'D: \ oracle \ oradata \ Oracle

MySql remote connection settings problems

If you use the web and not on the same database server, MySQL server, you need to allow remote link to the site to work properly. MySQL remote link set two ways: 1. Change table method. Your account may be allowed from a remote landing, only localhos

Mysql forgotten password solution (network excerpt)

In the windows: Open a command window, stop the mysql service: Net stop mysql The installation path to the mysql start mysql, in the bin directory using mysqld-nt.exe start, execute the command line window: mysqld-nt - skip-grant-tables Then open ano

oracle table privileges

from: B7% BF% B6% F7% BA% EA/blog/item/e2ff5c8b3772d3d8fd1f101a.html alter any cluster of rights to modify any cluster alter any index permissions to modify any indexes alter any ro

linux install Mysql5.0.18

1> Mysql-5.0.18.tar.gz tools via SSH upload to the Linux system's home directory 2> set up MySQL users and groups: # Groupadd mysql # Useradd-g mysql mysql Copy code 3> decompress Mysql-5.0.18.tar.gz Source package # Cd / home # Tar zxvf

mysql master master synchronization

A server: host port 3306 B Server: host port 3306 1, the authorized user: A server mysql> grant replication slave, file on *.* to 'repl9' @ '192 .168.1.102 'identified by '1234569'; Query OK, 0 r

Login access problems after installing MySQL

/ / Modify the mysql root user's password, the default security state when empty. 1 stop mysql / Etc / init.d / mysql stop 2 Executive: mysqld_safe - user = mysql - skip-grant-tables - skip-networking & (do not know what that means) 3 execute

Daquan Mysql commonly used commands, turn

Mysql commonly used commands show databases; display database create database name; create a database use databasename; Select database drop database name directly delete the database, not to remind the show tables; display tables describe tablename; disp

mysql-related operating records

Such as addressing Host 'HostName' is not allowed to connect to this MySQL server Solution: 1, assign permissions to grant all privileges on test .* to 'sinykk'@'%' identified by' sinykk '; 2, turn off the firewall If

2 mysql useful commands used

show create table mytable; show index from mytable; show culumn from mytable; show privileges; show variables; show global variables; show session variables; select current_user; UCASE,CONCAT(str,'',name),left(str,1),MOD(30,8) SQRT(30),ROUND(3,0)COAL

Oracle study notes (c)

Oracle to pass rights --sky User login grant all on mytab to sinitek;-- Licensing mytab all rights to sinitek --sinitek User login grant all on sky.mytab to freedom-- Authorized sky table mytab To freedom users -- Reports an error ,ORA-01929: Does no

Oracle notes: Statspack installation

As the saying goes, we must first sharpen his tools. Do database performance analysis, and must have a good tool. oracle statspack is free and comes with a powerful performance analysis tools. Statspack installation requires a user with sysdba privil

Install oracle database with

alter user scott account lock; First, the system's default user sys; / / system administrator, with the highest authority system; / / the local administrator, the second highest permission scott; / / normal user, password, default is tiger, the d

OracleDBA way of Oracle Instance (b)

Oracle needs to read at boot time initialization parameter file as a text file PFILE $ ORACLE_HOME / dbs directory, create a PFILE DBCA Created by hand cp init.ora $ ORACLE_HOME / dbs / initSID.ora Modify initSID.ora dbca to create database, Oracle s

rman nocatalog and catalog the differences

One. Nocatalog Nocatalog way is to use the control file as the catalog, each time a backup control file which must be written to a lot of backup information, which more and more control file backup information. Therefore, when using rman nocatalog wa

oracle debug privileges

GRANT debug any procedure, debug connect session TO username

SQL statement to achieve: Access database and SQL database interaction - a practical example

SQL Query Analyzer using the SQL statement to achieve: Access database and SQL database interaction - a practical example (1) Note that the first operation on the database privileges: sp_configure 'show advanced options', 1; - 0 is off GO REC

dblink remote stored procedure calls to achieve

Steps: 1 - Create DBLink create public database link testLink connect to l2108 identified by websms using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = (PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = inomc )))

MySql database to create a simple user and permission given

Do not talk nonsense, directly on the code. /* // Create a database user Create user yc identified by '123456' // Delete a database user Drop user yc // Modifying passwords SET Password FOR hity@"%" = password('1234') // Give database users specific

oracle 10g, you can not create an instance using the spfile has

I. Creating SPFILE Default, ORACLE database using the PFILE startup, SPFILE from the PFILE must be created, the newly created SPFILE Take effect the next time you start the database, CREATE SPFILE need SYSDBA or SYSOPER privileges: Syntax is as follo


mysqld server maintains two variables. Global variables affect the server's global operations. Session variables affect the operations related to the specific client connection. Server starts, all global variables are initialized to default value

mysql storage engine MyISAM concurrent insert

Know that the MySQL database is a database with a variety of storage engines, the most commonly used MyISAM and InnoDB, two storage engines. InnoDB supports foreign keys, support for transaction security, data, multi-version read, improved locking me
Recent Entries
Tag Cloud
Random Entries