How To Fix aws Command Error “You must specify a region”

Author: erics, July 29th, 2021

I was getting error “You must specify a region” when running any aws CLI command. The fix: Using the aws command:

aws configure set region us-east-1 --profile demo

1	aws configure set region us-east-1 --profile demo

which will automatically add the following to the file ~/.aws/config:

[profile demo]
region = us-east-1

1 2	[profile demo] region = us-east-1

You many simply edit the ~/.aws/config file yourself and append the same thing:

vi ~/.aws/config

[profile demo]
region = us-east-1

vi ~/.aws/config

[profile demo]

region = us-east-1

Categories: How-To's, Technology Tags: AWS, aws cli, aws command, aws configure, aws set, cli, Command, Config, configure, Error, Region, You must specify a region | No comments

How To Configure GIT To Push The Current Branch Only

Author: erics, March 16th, 2021

Recent changes to git have made the push default choice a bit confusing – “matching” vs. “simple” I picked “matching” when prompted. This means that git push by itself will try to push ALL local branches, not just the one you are working on. Personally, I find that a bit mad, so I decided to […]

Categories: How-To's, Technology Tags: Config, Default, defaults, git, git config, git push, Matching, Push, Simple | No comments

How To Fix Bamboo Start Errors After Java Upgrade

Author: erics, January 21st, 2020

PROBLEM DEFINITION Bamboo Catalina error found in catalina.out:

-Djava.endorsed.dirs=/volumes/data/bamboo/current/endorsed is not supported. Endorsed standards and standalone APIs
in modular form will be supported via the concept of upgradeable modules.
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.

-Djava.endorsed.dirs=/volumes/data/bamboo/current/endorsed is not supported. Endorsed standards and standalone APIs

in modular form will be supported via the concept of upgradeable modules.

Error: Could not create the Java Virtual Machine.

Error: A fatal exception has occurred. Program will exit.

SOLUTION SUMMARY Correct by using Java 8 instead. Do it manually using alternatives –set, or interactively using alternatives –config. MANUAL PROCEDURE – two steps, one for java and one for javac

alternatives --set java /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/java
alternatives --set javac /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/javac

1 2	alternatives --set java /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/java alternatives --set javac /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/javac

INTERACTIVE PROCEDURE – two steps, one for java and one for javac

root@bamboo:/root # alternatives --config javac

There are 3 programs which provide 'javac'.

  Selection    Command
-----------------------------------------------
 + 1           /usr/lib/jvm/java-1.8.0-openjdk.x86_64/bin/javac
*  2           /usr/lib/jvm/java-11-amazon-corretto/bin/javac
   3           /usr/lib/jvm/java-1.7.0-openjdk.x86_64/bin/javac

Enter to keep the current selection[+], or type selection number: 

root@bamboo:/root # alternatives --config java

There are 4 programs which provide 'java'.

  Selection    Command
-----------------------------------------------
 + 1           /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/java
   2           /usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java
*  3           /usr/lib/jvm/java-11-amazon-corretto/bin/java
   4           /usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java

Enter to keep the current selection[+], or type selection number:

root@bamboo:/root # alternatives --config javac

There are 3 programs which provide 'javac'.

Selection Command

-----------------------------------------------

+ 1 /usr/lib/jvm/java-1.8.0-openjdk.x86_64/bin/javac

* 2 /usr/lib/jvm/java-11-amazon-corretto/bin/javac

3 /usr/lib/jvm/java-1.7.0-openjdk.x86_64/bin/javac

Enter to keep the current selection[+], or type selection number:

root@bamboo:/root # alternatives --config java

There are 4 programs which provide 'java'.

Selection Command

-----------------------------------------------

+ 1 /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/java

2 /usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java

* 3 /usr/lib/jvm/java-11-amazon-corretto/bin/java

4 /usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java

Enter to keep the current selection[+], or type selection number:

Categories: How-To's, Technology Tags: alternatives, Bamboo, Catalina, catalina.out, Config, Endorsed, Endorsed standards, howto, Java, Java 8, java upgrade, java.endorsed.dirs, javac, set, tips, upgrade, Yum, yum update | No comments

What is the Best Way to Check the Health of a Tungsten Cluster Before a Switch?

Author: erics, June 26th, 2019

Latency-sensitive applications running in Java sometimes experience unacceptable delays under heavy I/O load. This blog discusses why this problem occurs and what to do about it for applications running Tungsten Clustering for MySQL.

Categories: Cluster, JVM, Mastering Tungsten Clustering, Tune Tags: Clustering, Config, Configuration, Memory, mysql, Network, Switch, Tungsten, tuning | Comments Off on What is the Best Way to Check the Health of a Tungsten Cluster Before a Switch?

How To Make Firefox Focus on the URL not Search in a New Tab

Author: erics, September 5th, 2017

Set browser.autofocus to false in about:config

Categories: How-To's, Technology Tags: about:config, AutoFocus, Browser, browser.autofocus, Config, configure, Firefox, Focus, New Tab, search, Tab, URL | No comments

How To Find the MySQL Config File

Author: erics, October 2nd, 2013

/usr/sbin/mysqld –verbose –help | grep -A 1 “Default options”

Categories: How-To's, Technology Tags: CNF, Config, Default, howto, my.cnf, mysql, Options, Path, tips | No comments

How To Force WordPress to Connect to the Database via TCP

Author: erics, October 2nd, 2013

wp-config.php

define('DB_HOST', '127.0.0.1:3306');
define('DB_PORT', 3306);

1 2	define('DB_HOST', '127.0.0.1:3306'); define('DB_PORT', 3306);

Categories: How-To's, Technology Tags: 127.0.0.1, 3306, Config, Connect, Database, DB_HOST, DB_PORT, Force, howto, mysql, TCP, tips, WordPress, wp-config, wp-config.php | No comments

How To Keep SSH Alive In MacOSX Lion Terminal Sessions

Author: erics, May 24th, 2012

Apple’s 10.7 Lion, is NOT my favorite iteration of MacOSX. They continue to make the OS more Windows-like, which means they have started down that slippery slope… In Snow Leopard, I could have my ssh sessions running for weeks. In Lion, the ssh sessions time out with nasty errors, including “Write failed: Broken pipe”. After […]

Categories: How-To's, Technology Tags: apple, Config, howto, Keepalive, Lion, Mac, macosx, OSX, ssh, Terminal, tips | 4 comments

Where To Find MySQL Sample my.cnf Configuration Files On Amazon Linux

Author: erics, February 9th, 2012

YMMV… /usr/share/doc/mysql-server-5.1.52

Categories: How-To's, Technology Tags: AWS, CentOS, Config, Configuration, howto, Linux, my.cnf, mysql, Sample, tips, Where, WhereTo | No comments

How To Configure MySQL For phpMyAdmin

Author: erics, July 29th, 2011

Securely, allow access ONLY from the local server NOT from the network

GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
GRANT SELECT (
    Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
    Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
    File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
    Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
    Execute_priv, Repl_slave_priv, Repl_client_priv
    ) ON mysql.user TO 'pma'@'localhost';
GRANT SELECT ON mysql.db TO 'pma'@'localhost';
GRANT SELECT ON mysql.host TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
    ON mysql.tables_priv TO 'pma'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';

GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';

GRANT SELECT (

Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,

Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,

File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,

Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,

Execute_priv, Repl_slave_priv, Repl_client_priv

) ON mysql.user TO 'pma'@'localhost';

GRANT SELECT ON mysql.db TO 'pma'@'localhost';

GRANT SELECT ON mysql.host TO 'pma'@'localhost';

GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)

ON mysql.tables_priv TO 'pma'@'localhost';

GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';

Insecurely, allow access via the network

GRANT USAGE ON mysql.* TO 'pma'@'%' IDENTIFIED BY 'pmapass';
GRANT SELECT (
    Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
    Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
    File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
    Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
    Execute_priv, Repl_slave_priv, Repl_client_priv
    ) ON mysql.user TO 'pma'@'%';
GRANT SELECT ON mysql.db TO 'pma'@'%';
GRANT SELECT ON mysql.host TO 'pma'@'%';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
    ON mysql.tables_priv TO 'pma'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'%';

GRANT USAGE ON mysql.* TO 'pma'@'%' IDENTIFIED BY 'pmapass';

GRANT SELECT (

Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,

Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,

File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,

Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,

Execute_priv, Repl_slave_priv, Repl_client_priv

) ON mysql.user TO 'pma'@'%';

GRANT SELECT ON mysql.db TO 'pma'@'%';

GRANT SELECT ON mysql.host TO 'pma'@'%';

GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)

ON mysql.tables_priv TO 'pma'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'%';

With Table Creation SQL

-- --------------------------------------------------------
-- 
-- Database : `phpmyadmin`
-- 
CREATE DATABASE IF NOT EXISTS `phpmyadmin`
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE phpmyadmin;

-- --------------------------------------------------------

-- 
-- Privileges
-- 
GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'pma'@localhost;

-- --------------------------------------------------------

-- 
-- Table structure for table `pma_bookmark`
-- 

CREATE TABLE IF NOT EXISTS `pma_bookmark` (
  `id` int(11) NOT NULL auto_increment,
  `dbase` varchar(255) NOT NULL default '',
  `user` varchar(255) NOT NULL default '',
  `label` varchar(255) COLLATE utf8_general_ci NOT NULL default '',
  `query` text NOT NULL,
  PRIMARY KEY  (`id`)
)
  ENGINE=MyISAM COMMENT='Bookmarks'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table `pma_column_info`
-- 

CREATE TABLE IF NOT EXISTS `pma_column_info` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `db_name` varchar(64) NOT NULL default '',
  `table_name` varchar(64) NOT NULL default '',
  `column_name` varchar(64) NOT NULL default '',
  `comment` varchar(255) COLLATE utf8_general_ci NOT NULL default '',
  `mimetype` varchar(255) COLLATE utf8_general_ci NOT NULL default '',
  `transformation` varchar(255) NOT NULL default '',
  `transformation_options` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
)
  ENGINE=MyISAM COMMENT='Column information for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table `pma_history`
-- 

CREATE TABLE IF NOT EXISTS `pma_history` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `username` varchar(64) NOT NULL default '',
  `db` varchar(64) NOT NULL default '',
  `table` varchar(64) NOT NULL default '',
  `timevalue` timestamp NOT NULL,
  `sqlquery` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `username` (`username`,`db`,`table`,`timevalue`)
)
  ENGINE=MyISAM COMMENT='SQL history for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table `pma_pdf_pages`
-- 

CREATE TABLE IF NOT EXISTS `pma_pdf_pages` (
  `db_name` varchar(64) NOT NULL default '',
  `page_nr` int(10) unsigned NOT NULL auto_increment,
  `page_descr` varchar(50) COLLATE utf8_general_ci NOT NULL default '',
  PRIMARY KEY  (`page_nr`),
  KEY `db_name` (`db_name`)
)
  ENGINE=MyISAM COMMENT='PDF relation pages for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `pma_recent`
--

CREATE TABLE IF NOT EXISTS `pma_recent` (
  `username` varchar(64) NOT NULL,
  `tables` text NOT NULL,
  PRIMARY KEY (`username`)
)
  ENGINE=MyISAM COMMENT='Recently accessed tables'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `pma_table_uiprefs`
--

CREATE TABLE IF NOT EXISTS `pma_table_uiprefs` (
  `username` varchar(64) NOT NULL,
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  `prefs` text NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`username`,`db_name`,`table_name`)
)
  ENGINE=MyISAM COMMENT='Tables'' UI preferences'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table `pma_relation`
-- 

CREATE TABLE IF NOT EXISTS `pma_relation` (
  `master_db` varchar(64) NOT NULL default '',
  `master_table` varchar(64) NOT NULL default '',
  `master_field` varchar(64) NOT NULL default '',
  `foreign_db` varchar(64) NOT NULL default '',
  `foreign_table` varchar(64) NOT NULL default '',
  `foreign_field` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`master_db`,`master_table`,`master_field`),
  KEY `foreign_field` (`foreign_db`,`foreign_table`)
)
  ENGINE=MyISAM COMMENT='Relation table'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table `pma_table_coords`
-- 

CREATE TABLE IF NOT EXISTS `pma_table_coords` (
  `db_name` varchar(64) NOT NULL default '',
  `table_name` varchar(64) NOT NULL default '',
  `pdf_page_number` int(11) NOT NULL default '0',
  `x` float unsigned NOT NULL default '0',
  `y` float unsigned NOT NULL default '0',
  PRIMARY KEY  (`db_name`,`table_name`,`pdf_page_number`)
)
  ENGINE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table `pma_table_info`
-- 

CREATE TABLE IF NOT EXISTS `pma_table_info` (
  `db_name` varchar(64) NOT NULL default '',
  `table_name` varchar(64) NOT NULL default '',
  `display_field` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`db_name`,`table_name`)
)
  ENGINE=MyISAM COMMENT='Table information for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table `pma_designer_coords`
-- 

CREATE TABLE IF NOT EXISTS `pma_designer_coords` (
  `db_name` varchar(64) NOT NULL default '',
  `table_name` varchar(64) NOT NULL default '',
  `x` INT,
  `y` INT,
  `v` TINYINT,
  `h` TINYINT,
  PRIMARY KEY (`db_name`,`table_name`)
)
  ENGINE=MyISAM COMMENT='Table coordinates for Designer'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table `pma_tracking`
-- 

CREATE TABLE IF NOT EXISTS `pma_tracking` (
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  `version` int(10) unsigned NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  `schema_snapshot` text NOT NULL,
  `schema_sql` text,
  `data_sql` longtext,
  `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') default NULL,
  `tracking_active` int(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`db_name`,`table_name`,`version`)
)
  ENGINE=MyISAM ROW_FORMAT=COMPACT COMMENT='Database changes tracking for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `pma_userconfig`
--

CREATE TABLE IF NOT EXISTS `pma_userconfig` (
  `username` varchar(64) NOT NULL,
  `timevalue` timestamp NOT NULL,
  `config_data` text NOT NULL,
  PRIMARY KEY  (`username`)
)
  ENGINE=MyISAM COMMENT='User preferences storage for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

-- --------------------------------------------------------

-- Database : `phpmyadmin`

CREATE DATABASE IF NOT EXISTS `phpmyadmin`

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

USE phpmyadmin;

-- --------------------------------------------------------

-- Privileges

GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'pma'@localhost;

-- --------------------------------------------------------

-- Table structure for table `pma_bookmark`

CREATE TABLE IF NOT EXISTS `pma_bookmark` (

`id` int(11) NOT NULL auto_increment,

`dbase` varchar(255) NOT NULL default '',

`user` varchar(255) NOT NULL default '',

`label` varchar(255) COLLATE utf8_general_ci NOT NULL default '',

`query` text NOT NULL,

PRIMARY KEY (`id`)

)

ENGINE=MyISAM COMMENT='Bookmarks'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_column_info`

CREATE TABLE IF NOT EXISTS `pma_column_info` (

`id` int(5) unsigned NOT NULL auto_increment,

`db_name` varchar(64) NOT NULL default '',

`table_name` varchar(64) NOT NULL default '',

`column_name` varchar(64) NOT NULL default '',

`comment` varchar(255) COLLATE utf8_general_ci NOT NULL default '',

`mimetype` varchar(255) COLLATE utf8_general_ci NOT NULL default '',

`transformation` varchar(255) NOT NULL default '',

`transformation_options` varchar(255) NOT NULL default '',

PRIMARY KEY (`id`),

UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)

)

ENGINE=MyISAM COMMENT='Column information for phpMyAdmin'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_history`

CREATE TABLE IF NOT EXISTS `pma_history` (

`id` bigint(20) unsigned NOT NULL auto_increment,

`username` varchar(64) NOT NULL default '',

`db` varchar(64) NOT NULL default '',

`table` varchar(64) NOT NULL default '',

`timevalue` timestamp NOT NULL,

`sqlquery` text NOT NULL,

PRIMARY KEY (`id`),

KEY `username` (`username`,`db`,`table`,`timevalue`)

)

ENGINE=MyISAM COMMENT='SQL history for phpMyAdmin'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_pdf_pages`

CREATE TABLE IF NOT EXISTS `pma_pdf_pages` (

`db_name` varchar(64) NOT NULL default '',

`page_nr` int(10) unsigned NOT NULL auto_increment,

`page_descr` varchar(50) COLLATE utf8_general_ci NOT NULL default '',

PRIMARY KEY (`page_nr`),

KEY `db_name` (`db_name`)

)

ENGINE=MyISAM COMMENT='PDF relation pages for phpMyAdmin'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_recent`

CREATE TABLE IF NOT EXISTS `pma_recent` (

`username` varchar(64) NOT NULL,

`tables` text NOT NULL,

PRIMARY KEY (`username`)

)

ENGINE=MyISAM COMMENT='Recently accessed tables'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_table_uiprefs`

CREATE TABLE IF NOT EXISTS `pma_table_uiprefs` (

`username` varchar(64) NOT NULL,

`db_name` varchar(64) NOT NULL,

`table_name` varchar(64) NOT NULL,

`prefs` text NOT NULL,

`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`username`,`db_name`,`table_name`)

)

ENGINE=MyISAM COMMENT='Tables'' UI preferences'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_relation`

CREATE TABLE IF NOT EXISTS `pma_relation` (

`master_db` varchar(64) NOT NULL default '',

`master_table` varchar(64) NOT NULL default '',

`master_field` varchar(64) NOT NULL default '',

`foreign_db` varchar(64) NOT NULL default '',

`foreign_table` varchar(64) NOT NULL default '',

`foreign_field` varchar(64) NOT NULL default '',

PRIMARY KEY (`master_db`,`master_table`,`master_field`),

KEY `foreign_field` (`foreign_db`,`foreign_table`)

)

ENGINE=MyISAM COMMENT='Relation table'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_table_coords`

CREATE TABLE IF NOT EXISTS `pma_table_coords` (

`db_name` varchar(64) NOT NULL default '',

`table_name` varchar(64) NOT NULL default '',

`pdf_page_number` int(11) NOT NULL default '0',

`x` float unsigned NOT NULL default '0',

`y` float unsigned NOT NULL default '0',

PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)

)

ENGINE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_table_info`

CREATE TABLE IF NOT EXISTS `pma_table_info` (

`db_name` varchar(64) NOT NULL default '',

`table_name` varchar(64) NOT NULL default '',

`display_field` varchar(64) NOT NULL default '',

PRIMARY KEY (`db_name`,`table_name`)

)

ENGINE=MyISAM COMMENT='Table information for phpMyAdmin'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_designer_coords`

CREATE TABLE IF NOT EXISTS `pma_designer_coords` (

`db_name` varchar(64) NOT NULL default '',

`table_name` varchar(64) NOT NULL default '',

`x` INT,

`y` INT,

`v` TINYINT,

`h` TINYINT,

PRIMARY KEY (`db_name`,`table_name`)

)

ENGINE=MyISAM COMMENT='Table coordinates for Designer'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_tracking`

CREATE TABLE IF NOT EXISTS `pma_tracking` (

`db_name` varchar(64) NOT NULL,

`table_name` varchar(64) NOT NULL,

`version` int(10) unsigned NOT NULL,

`date_created` datetime NOT NULL,

`date_updated` datetime NOT NULL,

`schema_snapshot` text NOT NULL,

`schema_sql` text,

`data_sql` longtext,

`tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') default NULL,

`tracking_active` int(1) unsigned NOT NULL default '1',

PRIMARY KEY (`db_name`,`table_name`,`version`)

)

ENGINE=MyISAM ROW_FORMAT=COMPACT COMMENT='Database changes tracking for phpMyAdmin'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- Table structure for table `pma_userconfig`

CREATE TABLE IF NOT EXISTS `pma_userconfig` (

`username` varchar(64) NOT NULL,

`timevalue` timestamp NOT NULL,

`config_data` text NOT NULL,

PRIMARY KEY (`username`)

)

ENGINE=MyISAM COMMENT='User preferences storage for phpMyAdmin'

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

Categories: How-To's, Technology Tags: Config, Install, mysql, phpmyadmin | No comments

How To Fix aws Command Error “You must specify a region”

How To Configure GIT To Push The Current Branch Only

How To Fix Bamboo Start Errors After Java Upgrade

What is the Best Way to Check the Health of a Tungsten Cluster Before a Switch?

How To Make Firefox Focus on the URL not Search in a New Tab

How To Find the MySQL Config File

How To Force WordPress to Connect to the Database via TCP

How To Keep SSH Alive In MacOSX Lion Terminal Sessions

Where To Find MySQL Sample my.cnf Configuration Files On Amazon Linux

How To Configure MySQL For phpMyAdmin

Our Link Network

Business

Client Websites

Fine Dining

Friends & Family

Galleries

Health

Resources

Technology

Travel

The Archives

Latest Ramblings…

Various Topics of No Interest