<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-3918599997307089774</id><updated>2024-10-06T22:11:38.420-07:00</updated><title type='text'>Pentadbir Linux</title><subtitle type='html'>Aku hanyalah machai yg mengabdikan diri pd dunia Linux.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://pentadbirlinux.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3918599997307089774/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://pentadbirlinux.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Syariman</name><uri>http://www.blogger.com/profile/05416349776605642643</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>3</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-3918599997307089774.post-1512807648798297073</id><published>2011-05-04T05:17:00.000-07:00</published><updated>2011-05-04T05:17:57.080-07:00</updated><title type='text'>Install Mysql</title><content type='html'>&lt;iframe align=&quot;left&quot; frameborder=&quot;0&quot; marginheight=&quot;0&quot; marginwidth=&quot;0&quot; scrolling=&quot;no&quot; src=&quot;http://rcm.amazon.com/e/cm?t=namirays&amp;amp;o=1&amp;amp;p=8&amp;amp;l=bpl&amp;amp;asins=0764579495&amp;amp;fc1=000000&amp;amp;IS2=1&amp;amp;lt1=_blank&amp;amp;m=amazon&amp;amp;lc1=0000FF&amp;amp;bc1=000000&amp;amp;bg1=FFFFFF&amp;amp;f=ifr&quot; style=&quot;height: 245px; padding-right: 10px; padding-top: 5px; width: 131px;&quot;&gt;&lt;/iframe&gt;[root@www ~]# yum -y install mysql-server&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
[root@www ~]#/etc/rc.d/init.d/mysqld start&lt;br /&gt;
&lt;br /&gt;
Initializing MySQL database:  Installing all prepared tables&lt;br /&gt;
Fill help tables&lt;br /&gt;
&lt;br /&gt;
To start mysqld at boot time you have to copy support-files/mysql.server&lt;br /&gt;
to the right place for your system&lt;br /&gt;
&lt;br /&gt;
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !&lt;br /&gt;
To do so, start the server, then issue the following commands:&lt;br /&gt;
/usr/bin/mysqladmin -u root password &#39;new-password&#39;&lt;br /&gt;
/usr/bin/mysqladmin -u root -h www.server-linux.info password &#39;new-password&#39;&lt;br /&gt;
See the manual for more instructions.&lt;br /&gt;
&lt;br /&gt;
You can start the MySQL daemon with:&lt;br /&gt;
cd /usr ; /usr/bin/mysqld_safe &amp;amp;&lt;br /&gt;
&lt;br /&gt;
You can test the MySQL daemon with the benchmarks in the &#39;sql-bench&#39; directory:&lt;br /&gt;
cd sql-bench ; perl run-all-tests&lt;br /&gt;
&lt;br /&gt;
Please report any problems with the /usr/bin/mysqlbug script!&lt;br /&gt;
&lt;br /&gt;
The latest information about MySQL is available on the web at http://www.mysql.com&lt;br /&gt;
Support MySQL by buying support/licenses at http://shop.mysql.com&lt;br /&gt;
Starting MySQL: &amp;nbsp;&amp;nbsp;&amp;nbsp; [ &amp;nbsp;OK&amp;nbsp; ]&lt;br /&gt;
&lt;br /&gt;
[root@www ~]#chkconfig mysqld on&lt;br /&gt;
&lt;br /&gt;
[root@www ~]#mysql -u root&lt;div class=&quot;pos5&quot;&gt;&lt;div class=&quot;color2&quot;&gt;# login to MySQL&lt;/div&gt;&lt;/div&gt;&lt;br /&gt;
Welcome to the MySQL monitor.  Commands end with ; or g.&lt;br /&gt;
Your MySQL connection id is 2 to server version: 5.0.22&lt;br /&gt;
&lt;br /&gt;
Type &#39;help;&#39; or &#39;\h&#39; for help. Type &#39;\c&#39; to clear the buffer.&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;color2&quot;&gt;# show user info&lt;/div&gt;&lt;br /&gt;
mysql&amp;gt; &lt;div class=&quot;color1&quot;&gt;select user,host,password from mysql.user;&lt;/div&gt;&lt;br /&gt;
&lt;div style=&quot;display: block;&quot;&gt;&lt;img alt=&quot;&quot; height=&quot;134&quot; src=&quot;http://www.server-world.info/en/CentOS_5/mysql/img/1.jpg&quot; width=&quot;450&quot; /&gt;&lt;/div&gt;4 rows in set (0.00 sec)&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;color2&quot;&gt;# set root password&lt;/div&gt;&lt;br /&gt;
mysql&amp;gt; &lt;div class=&quot;color1&quot;&gt;set password for root@localhost=password(&#39;password&#39;);&lt;/div&gt;&lt;br /&gt;
Query OK, 0 rows affected (0.00 sec)&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;color2&quot;&gt;# set root password&lt;/div&gt;&lt;br /&gt;
mysql&amp;gt;set password for root@&#39;www.server-linux.info&#39;=password(&#39;password&#39;);&lt;br /&gt;
Query OK, 0 rows affected (0.00 sec)&lt;br /&gt;
&lt;br /&gt;
mysql&amp;gt;select user,host,password from mysql.user;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;display: block;&quot;&gt;&lt;img alt=&quot;&quot; height=&quot;134&quot; src=&quot;http://www.server-world.info/en/CentOS_5/mysql/img/2.jpg&quot; width=&quot;450&quot; /&gt;&lt;/div&gt;4 rows in set (0.00 sec)&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;color2&quot;&gt;# delete anonymous users&lt;/div&gt;&lt;br /&gt;
mysql&amp;gt;delete from mysql.user where user=&#39;&#39;;&lt;br /&gt;
Query OK, 2 rows affected (0.00 sec)&lt;br /&gt;
&lt;br /&gt;
mysql&amp;gt;select user,host,password from mysql.user;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;display: block;&quot;&gt;&lt;img alt=&quot;&quot; height=&quot;96&quot; src=&quot;http://www.server-world.info/en/CentOS_5/mysql/img/3.jpg&quot; width=&quot;450&quot; /&gt;&lt;/div&gt;2 rows in set (0.00 sec)&lt;br /&gt;
&lt;br /&gt;
mysql&amp;gt; &lt;div class=&quot;color1&quot;&gt;exit&lt;/div&gt;&lt;div class=&quot;pos5&quot;&gt;&lt;div class=&quot;color2&quot;&gt;# logout&lt;/div&gt;&lt;/div&gt;&lt;br /&gt;
Bye&lt;br /&gt;
[root@www ~]#mysql -u root -p&lt;div class=&quot;pos5&quot;&gt;&lt;div class=&quot;color2&quot;&gt;# login as root&lt;/div&gt;&lt;/div&gt;&lt;br /&gt;
Enter password:# root password&lt;br /&gt;
&lt;br /&gt;
Welcome to the MySQL monitor.  Commands end with ; or g.&lt;br /&gt;
Your MySQL connection id is 4 to server version: 5.0.22&lt;br /&gt;
&lt;br /&gt;
Type &#39;help;&#39; or &#39;\h&#39; for help. Type &#39;\c&#39; to clear the buffer.&lt;br /&gt;
&lt;br /&gt;
mysql&amp;gt; &lt;br /&gt;
&lt;div class=&quot;color1&quot;&gt;exit&lt;/div&gt;&lt;br /&gt;
Bye</content><link rel='replies' type='application/atom+xml' href='http://pentadbirlinux.blogspot.com/feeds/1512807648798297073/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://pentadbirlinux.blogspot.com/2011/05/install-mysql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3918599997307089774/posts/default/1512807648798297073'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3918599997307089774/posts/default/1512807648798297073'/><link rel='alternate' type='text/html' href='http://pentadbirlinux.blogspot.com/2011/05/install-mysql.html' title='Install Mysql'/><author><name>Syariman</name><uri>http://www.blogger.com/profile/05416349776605642643</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3918599997307089774.post-3031040545566732438</id><published>2011-05-04T04:01:00.001-07:00</published><updated>2011-05-04T04:39:39.652-07:00</updated><title type='text'></title><content type='html'>&lt;iframe align=&quot;left&quot; frameborder=&quot;0&quot; marginheight=&quot;0&quot; marginwidth=&quot;0&quot; scrolling=&quot;no&quot; src=&quot;http://rcm.amazon.com/e/cm?t=namirays&amp;amp;o=1&amp;amp;p=8&amp;amp;l=bpl&amp;amp;asins=047048165X&amp;amp;fc1=000000&amp;amp;IS2=1&amp;amp;lt1=_blank&amp;amp;m=amazon&amp;amp;lc1=0000FF&amp;amp;bc1=000000&amp;amp;bg1=FFFFFF&amp;amp;f=ifr&quot; style=&quot;height: 245px; padding-right: 10px; padding-top: 5px; width: 131px;&quot;&gt;&lt;/iframe&gt;Make sure that Apache is installed by typing the following from a Terminal window:&lt;br /&gt;
&lt;pre&gt;[root@bigboy tmp]# rpm -qa | grep httpd&lt;/pre&gt;&lt;pre&gt;&amp;nbsp;&lt;/pre&gt;Start the httpd server. As root user, type the following:&lt;br /&gt;
&lt;pre&gt;[root@bigboy tmp]# service httpd start&lt;/pre&gt;&lt;pre&gt;&amp;nbsp;&lt;/pre&gt;Use the chkconfig command to configure Apache to start at boot: &lt;br /&gt;
&lt;pre&gt;[root@bigboy tmp]# chkconfig httpd on&lt;/pre&gt;&lt;br /&gt;
Use the &lt;code&gt;httpd&amp;lt;code&amp;gt; init script in the &amp;lt;code&amp;gt;/etc/init.d&lt;/code&gt; directory to start,stop, and restart Apache after booting: &lt;br /&gt;
&lt;pre&gt;[root@local tmp]# /etc/init.d/httpd start
     [root@local tmp]# /etc/init.d/httpd stop
     [root@local tmp]# /etc/init.d/httpd restart&lt;/pre&gt;&lt;br /&gt;
You can test whether the Apache process is running with &lt;br /&gt;
&lt;pre&gt;root@local tmp]# pgrep httpd&lt;/pre&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; you should get a response of plain old process ID numbers.&lt;br /&gt;
&lt;br /&gt;
To make sure that the Web Server is working, open Firefox (or another Web browser),&lt;br /&gt;
type the following into the Location box, and press [Enter]:&lt;br /&gt;
&lt;pre&gt;http://localhost/&lt;/pre&gt;</content><link rel='replies' type='application/atom+xml' href='http://pentadbirlinux.blogspot.com/feeds/3031040545566732438/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://pentadbirlinux.blogspot.com/2011/05/blog-post.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3918599997307089774/posts/default/3031040545566732438'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3918599997307089774/posts/default/3031040545566732438'/><link rel='alternate' type='text/html' href='http://pentadbirlinux.blogspot.com/2011/05/blog-post.html' title=''/><author><name>Syariman</name><uri>http://www.blogger.com/profile/05416349776605642643</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3918599997307089774.post-1105225837957579042</id><published>2011-05-04T00:12:00.000-07:00</published><updated>2011-05-04T01:20:09.189-07:00</updated><title type='text'>Auto back up database Mysql</title><content type='html'>&lt;span&gt;&lt;span style=&quot;background-color: white;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;iframe align=&quot;left&quot; frameborder=&quot;0&quot; marginheight=&quot;0&quot; marginwidth=&quot;0&quot; scrolling=&quot;no&quot; src=&quot;http://rcm.amazon.com/e/cm?t=namirays&amp;amp;o=1&amp;amp;p=8&amp;amp;l=bpl&amp;amp;asins=076456997X&amp;amp;fc1=000000&amp;amp;IS2=1&amp;amp;lt1=_blank&amp;amp;m=amazon&amp;amp;lc1=0000FF&amp;amp;bc1=000000&amp;amp;bg1=FFFFFF&amp;amp;f=ifr&quot; style=&quot;height: 245px; padding-right: 10px; padding-top: 5px; width: 131px;&quot;&gt;&amp;amp;amp;lt;span style=&quot;background-color: rgb(255, 255, 255);&quot;&amp;amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&lt;/iframe&gt;Alhamdulillah hari ni aku berjaya jumpa tool utk back up data2 mysql secara auto ke email dan jugak local.akhirnya aku berjumpa dgn &lt;span style=&quot;color: blue;&quot;&gt;phpMySQLAutoBackup&lt;/span&gt;.Tak payah lagi aku risau pasal critical data dah.asyik2 nk back up manual je dari server.Selalu aku export je database dari phpmyadmin.Jenuh2.Korang boleh download disini phpMySQLAutoBackup tu...&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.dwalker.co.uk/phpmysqlautobackup/&quot; style=&quot;color: #3366ff;&quot;&gt;http://www.dwalker.co.uk/phpmysqlautobackup/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Selamat Mencuba!!!</content><link rel='replies' type='application/atom+xml' href='http://pentadbirlinux.blogspot.com/feeds/1105225837957579042/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://pentadbirlinux.blogspot.com/2011/05/auto-back-up-database-mysql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3918599997307089774/posts/default/1105225837957579042'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3918599997307089774/posts/default/1105225837957579042'/><link rel='alternate' type='text/html' href='http://pentadbirlinux.blogspot.com/2011/05/auto-back-up-database-mysql.html' title='Auto back up database Mysql'/><author><name>Syariman</name><uri>http://www.blogger.com/profile/05416349776605642643</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>