Database Administrator

First, sudo apt-get install mysql-server mysql-clientAfter the installation is complete, the mysql service starts to run. You need to change the root password, but this situation often occurs.'Access denied for user' root' @ 'localhost' (using

You need to enable user permissions in Ubuntu7.10 and bind them to the mysql local machine. 1. Open the user permission under the command line: grant all privileges on drupal. * to user@192.168.1.80 identified by 'user-password '; On the

Default Value: transaction level is repeatable read for mysql. In this case, the data READ every time in a mysql session remains unchanged, regardless of the updates made to other transactions. in this way, the performance is relatively high, but it

Read Chinese data from MySQL ??? (Question mark) garbled solution: $ Db = & ADONewConnection ('mysql ');$ Db-> PConnect ($ dbhost, $ dbusr, $ dbpwd, $ dbname );Mysql_query ("set names 'gbk'"); // you can add this sentence.$ SQL = "select * from

Dump stored programs (functions and programs) in the dumped database ). The output produced using --- routines contains the create procedure and create function statements to recreate the subroutine. However, these statements do not include

1. Enable services in Linux[Xxx @ localhost ~] $ SuPassword:[Xxx @ localhost xxxxx] #/etc/init. d/mysqld startStart MySQL: [OK] 2. log on[Xxx @ localhost xxxxx # mysqlWelcome to the MySQL monitor. Commands end with; or \ g.Your MySQL connection id

Install the basic MySQL program in Ubuntu: Sudo apt-get install mysql-server mysql-client In this process, the mysql password is configured. Then install MySQL-ADMIN Sudo apt-get install mysql-admin Note: It is said that the

You can directly modify the sqlnet. ora file under $ OREACLE_HOME/network/admin and add the following content: Tcp. validnode_checking = yes # Ip addresses allowed for access Tcp. invited_nodes = (ip1, ip2 ,......) # Ip addresses not allowed for

An Oracle 10g Process System Study note: Since Oracle 10 Gb is a multi-process and multi-thread database, SQL Server is a single-process and multi-thread database. Oracle instances mainly have three types of processes. 1. server process 2.

1. Mysql installation package from http://www.mysql.com is blooming 2. Copy the mysql compressed package to the/usr/local/directory. # Cp mysql-standard-5.0.15-linux-gnu-i686-glibc23.tar.gz/usr/local 3. decompress the package to/usr/ocal/and change

In this article, I will discuss the steps required to delete a node from an existing Oracle RAC 10g second cluster. For demonstration purposes, the environment here is a two-node RedHat Linux cluster. Database Name Node number

There are two types of SQL statements used to operate databases: Query statements, SELECT statements, and update statements, which are also called data operation statements. The implication is to modify the data. There are three statements in

MySQL 5.6 GA is released, which is undoubtedly the best version of MySQL. If you do not know the new features and improvements of MySQL 5.6, you can learn from here. The main purpose of my article is to test the performance. I use Sysbench workloads

As the name suggests, slow query logs record queries with a long execution time. You can set a threshold to record all SQL statements whose running time exceeds this threshold to the slow query log file. The threshold value can be set using the long_

I. Description There are two types of RMAN backups: Catalog and Nocatalog. For Nocatalog, Oracle uses a control file to save some RMAN backup records. In fact, most of them also use Nocatalog for backup. It is easier to use Nocatalog. However, when

Project Background: The original Oracle database server runs on the HP DL388G7 server with 32 GB memory. Due to business growth, the memory is tight, and server hardware faults occur from time to time. This is caused by a single instance and single

Hive users can use alter statements to change table attributes. Alter PartitionsAdd partitions: Alter table table_nameADD [if not exists]PARTITION partition_spec [LOCATION 'location1']Partition_spec [LOCATION 'location2']...Partition_spec:(Partition_

Problem description: Oracle error 1691 is reported when data is imported through imp today. ORA-01691: Lob segment MID. SYS_LOB0000032765C00002 $ unable to scale through 1024 (in tablespace MID) Cause of the problem: I searched for it on the

CentOS6.3 32-bit operating system by default will install lib files such as mysql-libs-5.1.61-4.el6.i686, so it will conflict with the installation file MySQL5.6.10, the first installation is as follows (conflicts with is the meaning of conflict ): [

To save the trouble in the future, we can modify the mysql garbled characters in the configuration file under RHEL6.3. My mysql configuration file is/etc/my. cnf 1. First find [mysqld] in the configuration file and add the following