How To Install the AWS CLI

Author: erics, March 29th, 2016

http://docs.aws.amazon.com/cli/latest/userguide/cli-chap-getting-set-up.html http://docs.aws.amazon.com/cli/latest/userguide/cli-chap-getting-started.html AWS CLI v2

curl "https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip" -o "awscliv2.zip"
unzip awscliv2.zip
sudo ./aws/install

curl "https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip" -o "awscliv2.zip"

unzip awscliv2.zip

sudo ./aws/install

AWS CLI v1

cd
curl "https://s3.amazonaws.com/aws-cli/awscli-bundle.zip" -o "awscli-bundle.zip"
unzip awscli-bundle.zip
yum install python26
/usr/bin/python26 awscli-bundle/install -i /opt/aws/awscli -b /usr/bin/aws
aws configure
aws s3 ls
aws ec2 describe-instances --output text

curl "https://s3.amazonaws.com/aws-cli/awscli-bundle.zip" -o "awscli-bundle.zip"

unzip awscli-bundle.zip

yum install python26

/usr/bin/python26 awscli-bundle/install -i /opt/aws/awscli -b /usr/bin/aws

aws configure

aws s3 ls

aws ec2 describe-instances --output text

ls -l ~/.aws

total 8
-rw------- 1 root root  43 Mar 24 18:05 config
-rw------- 1 root root 116 Mar 24 18:05 credentials

total 8

-rw------- 1 root root 43 Mar 24 18:05 config

-rw------- 1 root root 116 Mar 24 18:05 credentials

cat ~/.aws/config

[default]
output = json
region = us-east-1

[default]

output = json

region = us-east-1

cat ~/.aws/credentials

[default]
aws_access_key_id = NNNNNNNNNNNNNNNNNNNN
aws_secret_access_key = NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

[default]

aws_access_key_id = NNNNNNNNNNNNNNNNNNNN

aws_secret_access_key = NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

Categories: How-To's, Technology Tags: AWS, cli, configure, Credentials, Creds, howto, Install, Python, python26, tips, Yum | No comments

How To Install Continuent Tungsten Replicator Using Puppet on AWS

Author: erics, April 15th, 2014

https://github.com/continuent/continuent-puppet-tungsten As user root: vi /root/install.pp

$clusterData = {
    "myServiceNameHere" => {
        "topology" => "master-slave",
        "master" => "myDBHostName1",
        "slaves" => "myDBHostName2",
    },
}
class { 'tungsten' :
    installSSHKeys => true,
    installMysql => true,
    clusterData => $clusterData,
    replicatorRepo => "stable",
    installReplicatorSoftware => true,
}

$clusterData = {

"myServiceNameHere" => {

"topology" => "master-slave",

"master" => "myDBHostName1",

"slaves" => "myDBHostName2",

}

class { 'tungsten' :

installSSHKeys => true,

installMysql => true,

clusterData => $clusterData,

replicatorRepo => "stable",

installReplicatorSoftware => true,

}

yum install puppet mkdir -p /etc/puppet/modules puppet module install continuent/tungsten puppet apply /root/install.pp

Categories: How-To's, Technology Tags: AWS, CentOS, Continuent, howto, Install, key, Master, Puppet, Replicator, Slave, ssh, tips, Tungsten | No comments

How To Configure CPAN to Automatically Install Dependencies Without Confirmation

Author: erics, March 20th, 2014

perl -MCPAN -e ‘my $c = “CPAN::HandleConfig”; $c->load(doit => 1, autoconfig => 1); $c->edit(prerequisites_policy => “follow”); $c->edit(connect_to_internet_ok => “yes”); $c->edit(build_requires_install_policy => “yes”); $c->commit’

Categories: How-To's, Technology Tags: Auto, Automatic, CPAN, Dependencies, Dependency, howto, Install, tips | No comments

How To install Boto on Amazon Linux using yum and pip

Author: erics, August 15th, 2013

yum install python
python /usr/bin/easy_install pip
pip install boto

yum install python

python /usr/bin/easy_install pip

pip install boto

Categories: How-To's, Technology Tags: Amazon, AWS, Boto, EC2, howto, Install, Linux, pip, Python, S3, tips, Yum | No comments

How To Install s3cmd

Author: erics, June 7th, 2013

Install Procedure Download and extract into /usr/local: http://downloads.sourceforge.net/project/s3tools/s3cmd/1.0.1/s3cmd-1.0.1.tar.gz

cd /usr/local/bin
ln -s /usr/local/s3cmd-1.0.1/s3cmd
/usr/local/bin/s3cmd --configure
Access Key: {ACCESS_KEY}
Secret Key: {SECRET_KEY}
Encryption password: {PASSWORD}

cd /usr/local/bin

ln -s /usr/local/s3cmd-1.0.1/s3cmd

/usr/local/bin/s3cmd --configure

Access Key: {ACCESS_KEY}

Secret Key: {SECRET_KEY}

Encryption password: {PASSWORD}

Configuration saved to ‘/root/.s3cfg’ Command Line Examples List all buckets: s3cmd ls Make a new bucket in the default region (US): s3cmd mb s3://{YOUR_BUCKET_HERE} Make a new bucket in a specific region: s3cmd mb –bucket-location={DATACENTER} s3://{YOUR_BUCKET_HERE} As of now the datacenters are: US (default), EU, us-west-1, […]

Categories: How-To's, Technology Tags: Amazon, AWS, howto, Install, rsync, S3, s3cfg, s3cmd, s3sync, s3tools, Sync, tips | No comments

How To Upgrade PHP to PHP53 On CentOS

Author: erics, August 22nd, 2011

# service httpd stop
# yum erase php-common php
# yum install php53*
# service httpd start

# service httpd stop

# yum erase php-common php

# yum install php53*

# service httpd start

To get mcrypt installed, read this post: http://www.ericmichaelstone.com/?p=4702

Categories: How-To's, Technology Tags: CentOS, Erase, howto, Install, mcrypt, php, PHP53, tips, upgrade, Yum | No comments

How To Install mcrypt For PHP53 On CentOS

Author: erics, August 12th, 2011

To get mcrypt support for PHP 5.3, compile and install just the mcrypt extension. First, get the prerequisites:

yum install php53-devel libmcrypt-devel gcc gcc-c++

1	yum install php53-devel libmcrypt-devel gcc gcc-c++

Download the php source code from php.net, for example:

wget http://mx2.php.net/get/php-5.3.6.tar.bz2/from/us3.php.net/mirror
tar xvjf php-5.3.6.tar.bz2

1 2	wget http://mx2.php.net/get/php-5.3.6.tar.bz2/from/us3.php.net/mirror tar xvjf php-5.3.6.tar.bz2

Now, cd to the proper place and follow these steps:

cd php-5.3.6/ext/mcrypt/
phpize
aclocal
./configure
make
make install

cd php-5.3.6/ext/mcrypt/

phpize

aclocal

./configure

make

make install

Create the configuration file for MCrypt /etc/php.d/mcrypt.ini containing:

extension=mcrypt.so

1	extension=mcrypt.so

Restart apache:

service http restart

1	service http restart

Create a file […]

Categories: How-To's, Technology Tags: compile, gcc, howto, Install, libmcrypt, mcrypt, mcrypt.ini, mcrypt.so, php, PHP53, phpmyadmin, tips | 2 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 Install MySQL 5.5 On CentOS Using RPM And Yum

Author: erics, July 29th, 2011

rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
yum --enablerepo=remi,remi-test install mysql mysql-server
chkconfig --levels 235 mysqld on
service mysqld start

rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

yum --enablerepo=remi,remi-test install mysql mysql-server

chkconfig --levels 235 mysqld on

service mysqld start

If you get this error: “Table ‘mysql.servers’ doesn’t exist”, do this:

CREATE TABLE `servers` ( 
`Server_name` char(64) NOT NULL, 
`Host` char(64) NOT NULL, 
`Db` char(64) NOT NULL, 
`Username` char(64) NOT NULL, 
`Password` char(64) NOT NULL, 
`Port` int(4) DEFAULT NULL, 
`Socket` char(64) DEFAULT NULL, 
`Wrapper` char(64) NOT NULL, 
`Owner` char(64) NOT NULL, 
PRIMARY KEY (`Server_name`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';

CREATE TABLE `servers` (

`Server_name` char(64) NOT NULL,

`Host` char(64) NOT NULL,

`Db` char(64) NOT NULL,

`Username` char(64) NOT NULL,

`Password` char(64) NOT NULL,

`Port` int(4) DEFAULT NULL,

`Socket` char(64) DEFAULT NULL,

`Wrapper` char(64) NOT NULL,

`Owner` char(64) NOT NULL,

PRIMARY KEY (`Server_name`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';

Categories: How-To's, Technology Tags: 5.5, CentOS, howto, Install, mysql, MySQL 5.5, mysqld, phpmyadmin, tips | No comments

How To Install Multiple Perl Modules From The Command Line

Author: erics, July 14th, 2010

Create a text file containing the list of desired modules, one per line. Name it “modules.txt”. Then execute this command: for module in cat modules.txt; do echo $module; perl -MCPAN -e “install $module”; done

Categories: How-To's, Technology Tags: cli, Command line, CPAN, Install, Install Multiple, Multiple, perl | No comments

How To Install the AWS CLI

How To Install Continuent Tungsten Replicator Using Puppet on AWS

How To Configure CPAN to Automatically Install Dependencies Without Confirmation

How To install Boto on Amazon Linux using yum and pip

How To Install s3cmd

How To Upgrade PHP to PHP53 On CentOS

How To Install mcrypt For PHP53 On CentOS

How To Configure MySQL For phpMyAdmin

How To Install MySQL 5.5 On CentOS Using RPM And Yum

How To Install Multiple Perl Modules From The Command Line

Our Link Network

Business

Client Websites

Fine Dining

Friends & Family

Galleries

Health

Resources

Technology

Travel

The Archives

Latest Ramblings…

Various Topics of No Interest