Search results

Create the page "mysql" on this wiki!

Page title matches

• Show mysql database locks
  from the mysql prompt... mysql> '''SHOW FULL PROCESSLIST;'''
  712 B (56 words) - 19:01, 25 February 2013
• Mysql backup and restore
  mysql -u root -h localhost -p < backup.sql Restoring a single database from a complete MySQL database dump
  1 KB (208 words) - 04:01, 12 June 2018
• Add, delete, modify mysql data with php
  580 B (75 words) - 22:19, 25 February 2013
• Gnucash mysql tables
  == command line mysql query for a job report == mysql -p database_name -e "select * from database_name.splits;"|grep 000003
  1 KB (203 words) - 01:52, 13 April 2014
• E107 change admin password with mysql
  mysql> '''use database_name;''' mysql> '''select * from e107_user;'''
  366 B (53 words) - 23:12, 26 February 2013
• monitor / log mysql queries
  http://www.howtogeek.com/howto/database/monitor-all-sql-queries-in-mysql/ [[category:mysql]]
  93 B (9 words) - 13:20, 12 April 2013
• Howto alter existing mysql table
  '''commands run from mysql interactive prompt''' [[category:mysql]]
  608 B (90 words) - 15:45, 12 April 2013
• Mysql delete data via cli
  mysql -h localhost -u root mediawikidb -e "DELETE FROM thelinuxwiki_user WHERE us [[category:mysql]]
  360 B (55 words) - 22:10, 8 February 2015
• Mysql reference
  Logging into mysql via command line: mysql -u root -h localhost -p
  7 KB (1,061 words) - 15:57, 12 April 2013
• Howto create mysql table
  mysql> use ''database_name''; mysql> CREATE TABLE example (
  5 KB (560 words) - 01:26, 27 July 2013
• Mysql error mysql.servers doesn't exist when running flush privileges command
  mysql> '''flush privileges;''' ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
  252 B (29 words) - 15:39, 17 May 2013
• Mysql server secure post install
  [[category:mysql]]
  106 B (16 words) - 15:41, 17 May 2013
• gnucash mysql invoice query
  mysql> '''SELECT guid FROM gnucash_database.invoices WHERE id = "2013018";''' mysql> '''SELECT date,description,action,quantity_num,i_price_num,i_discount_num,
  2 KB (196 words) - 15:05, 24 May 2013
• Mysql remote access
  enabled some settings in /etc/mysql/my.cnf @ mysql server prompt, ran..
  266 B (40 words) - 01:37, 27 July 2013
• MySQL database file location
  Installed mysql versions: 5.1.70 # cat /etc/mysql/my.cnf | grep datadir
  192 B (22 words) - 18:58, 12 June 2014
• mysql create new row via command line
  mysql> INSERT INTO tools_tbl (devicetype, toolname, model, manufacturer) VALUES ( [[category:mysql]]
  163 B (19 words) - 18:09, 24 February 2015
• mysql scratch
  [[category:mysql]]
  162 B (20 words) - 22:10, 26 February 2015
• mysql database size analysis
  ('mysql','information_schema')) AAA GROUP BY DB WITH ROLLUP) AA, [[category:mysql]]
  1 KB (152 words) - 03:01, 9 May 2016
• mysql server root password recovery
  Stop MySQL # sudo /etc/init.d/mysql stop
  427 B (61 words) - 03:07, 12 July 2016
• mysql set password
  [[category:mysql]]
  146 B (17 words) - 16:14, 25 May 2019
• delete mysql bin files to clear space
  ...o-rotated. The mechanisms for cleaning out the binlogs in conjunction with mysql-bin.index are: erase all binary logs before ‘mysql-bin.000223’.
  993 B (144 words) - 16:11, 17 November 2023

Page text matches

• Show mysql database locks
  from the mysql prompt... mysql> '''SHOW FULL PROCESSLIST;'''
  712 B (56 words) - 19:01, 25 February 2013
• Mysql backup and restore
  mysql -u root -h localhost -p < backup.sql Restoring a single database from a complete MySQL database dump
  1 KB (208 words) - 04:01, 12 June 2018
• E107 module writing
  == mysql db functions ==
  85 B (13 words) - 19:01, 25 February 2013
• Gnucash mysql tables
  == command line mysql query for a job report == mysql -p database_name -e "select * from database_name.splits;"|grep 000003
  1 KB (203 words) - 01:52, 13 April 2014
• E107 change admin password with mysql
  mysql> '''use database_name;''' mysql> '''select * from e107_user;'''
  366 B (53 words) - 23:12, 26 February 2013
• mail user auth failing after update
  courier erroneously tries to use the (not configured) mysql auth method.
  358 B (44 words) - 05:08, 4 April 2013
• monitor / log mysql queries
  http://www.howtogeek.com/howto/database/monitor-all-sql-queries-in-mysql/ [[category:mysql]]
  93 B (9 words) - 13:20, 12 April 2013
• Howto alter existing mysql table
  '''commands run from mysql interactive prompt''' [[category:mysql]]
  608 B (90 words) - 15:45, 12 April 2013
• Mysql delete data via cli
  mysql -h localhost -u root mediawikidb -e "DELETE FROM thelinuxwiki_user WHERE us [[category:mysql]]
  360 B (55 words) - 22:10, 8 February 2015
• Mysql reference
  Logging into mysql via command line: mysql -u root -h localhost -p
  7 KB (1,061 words) - 15:57, 12 April 2013
• Gnucash notes
  == gnucash + mysql== ...oge. The mysql option will be one of the "data format" choices. To enable mysql capability...
  323 B (47 words) - 15:26, 17 May 2013
• Howto create mysql table
  mysql> use ''database_name''; mysql> CREATE TABLE example (
  5 KB (560 words) - 01:26, 27 July 2013
• Mysql error mysql.servers doesn't exist when running flush privileges command
  mysql> '''flush privileges;''' ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
  252 B (29 words) - 15:39, 17 May 2013
• Mysql server secure post install
  [[category:mysql]]
  106 B (16 words) - 15:41, 17 May 2013
• mediawiki installation - database and file permissions
  mysql> show databases; | mysql |
  793 B (91 words) - 16:17, 10 July 2013
• gnucash mysql invoice query
  mysql> '''SELECT guid FROM gnucash_database.invoices WHERE id = "2013018";''' mysql> '''SELECT date,description,action,quantity_num,i_price_num,i_discount_num,
  2 KB (196 words) - 15:05, 24 May 2013
• Mysql remote access
  enabled some settings in /etc/mysql/my.cnf @ mysql server prompt, ran..
  266 B (40 words) - 01:37, 27 July 2013
• MySQL database file location
  Installed mysql versions: 5.1.70 # cat /etc/mysql/my.cnf | grep datadir
  192 B (22 words) - 18:58, 12 June 2014
• mysql create new row via command line
  mysql> INSERT INTO tools_tbl (devicetype, toolname, model, manufacturer) VALUES ( [[category:mysql]]
  163 B (19 words) - 18:09, 24 February 2015
• mysql scratch
  [[category:mysql]]
  162 B (20 words) - 22:10, 26 February 2015
• mysqld ambiguous error message
  # /etc/init.d/mysql start * Checking mysqld configuration for mysql ...
  723 B (96 words) - 13:23, 30 June 2015
• mysql database size analysis
  ('mysql','information_schema')) AAA GROUP BY DB WITH ROLLUP) AA, [[category:mysql]]
  1 KB (152 words) - 03:01, 9 May 2016
• mysql server root password recovery
  Stop MySQL # sudo /etc/init.d/mysql stop
  427 B (61 words) - 03:07, 12 July 2016
• drupal debian quick start
  apt-get install mysql-server php7.0 apache2 apt-get install php7.0-gd php7.0-xml php7.0-mysql
  510 B (59 words) - 18:30, 14 October 2018
• creating drupal database for install
  $ mysql -u username -p -e "CREATE DATABASE ''<databasename>'' CHARACTER SET utf8mb4 $ mysql -u username -p
  691 B (100 words) - 12:45, 4 April 2019
• viewing drupal logs from CLI
  example from mysql shell mysql> GRANT SELECT ON 'my_database_name'.* TO 'my_username'@'localhost' IDENTIFI
  478 B (73 words) - 12:03, 9 April 2019
• mysql set password
  [[category:mysql]]
  146 B (17 words) - 16:14, 25 May 2019
• sql join types explained
  [[category:mysql]]
  132 B (17 words) - 15:30, 3 June 2019
• delete mysql bin files to clear space
  ...o-rotated. The mechanisms for cleaning out the binlogs in conjunction with mysql-bin.index are: erase all binary logs before ‘mysql-bin.000223’.
  993 B (144 words) - 16:11, 17 November 2023