Owner: VPS Life URL:http://vpslife.blogspot.com/ Join Date: Thu, 09 Oct 2008 05:34:32 -0500 Rating:0 Site Description: Virtual Private Server problems and solutions Site statistics:Click here
How to reset root password on MySql? 2008-10-07 09:18:00 Pass the root mode on terminal.To stop mysql:# /etc/init.d/mysql stopAccess without privalages to mysql
# mysqld_safe --skip-grant-tables &Pass to the mysql
# mysql -u root
# use mysql;
# mysql -u root
# mysql>
INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv,
How to fix mysql thread_stack overrun? 2008-10-06 11:10:00 Today I faced a problem about running my stored procedure code and I got the error message :
#1436: Thread stack overrun: 4136 bytes used of a 131072 byte stack, and 131072 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.I tried the command mysqld -O thread_stack=# but it did not worked. Then I entered my.cnf file which is at /etc/my.cnf I found the value of thread_stack
Low Memory Mysql / Apache configurations 2008-10-04 07:51:00 Configurations will be good for 64Mb - 256Mb RAM If you would like to convert your InnoDB tables to MyISAM, you can use the shell script to automatically convert InnoDB tables to MyISAM. #!/bin/bash
MYSQLCMD=mysql
for db in `echo show databases | $MYSQLCMD | grep -v Database`; do
for table in `echo show tables | $MYSQLCMD $db | grep -v Tables_in_`; do
TABLE_TYPE=`echo show Read more:Apache
, Memory
Php Installation Differences: suphp mod_php cgi 2008-10-02 19:00:00 Apache Module (mod_php)
Most administrations tools (e.g. Plesk) need mod_php in order to work properly.
Advantages:
* speed
* needs less memory (RAM) than CGI
* php.ini values can be changed via PHP scripts, vhost files, .htaccess files
Disadvantages:
* Scripts are being executed with Apache privileges, which might lead to some security related problems
* Only one version Read more:Installation
Mysql Cheat Sheet 2008-10-02 18:15:00 Selecting a database:
# mysql USE database;
Listing databases:
# mysql SHOW DATABASES;
Listing tables in a db:
# mysql SHOW TABLES;
Describing the format of a table:
# mysql DESCRIBE table;
Creating a database:
# mysql CREATE DATABASE db_name;
Creating a table:
# mysql CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE));
# mysql CREATE TABLE pet (name VARCHAR(20), Read more:Cheat
How to disable selinux? 2008-10-02 14:53:00 You should edit /etc/sysconfig/selinux# vi /etc/sysconfig/selinux
file using an editor and make sure the paramater is:
SELINUX=disabled
How to open port on Linux? 2008-10-02 13:10:00 By default Linux
Operating Systems has a few ports open such as SSH(22) FTP(21) etc... However, we need more ports needed to open for another applications such as admin panels, several servers like apache, mysql and so on.
Open file with your favorite editor my own is vi:
# vi /etc/sysconfig/iptablesAdd following line to the file to enable https:// which is secure http for your server :
-A
Gain of performance for harddisk by using 32bits transfers 2008-10-02 12:47:00 Change harddisk data transfer bits:
Note: alpha can be hda, hda0, hda1
# hdparm -c3 /dev/hd(alpha)To test how much you gained type after reboot:
# hdparm -t -T /dev/hd(alpha)
How to delete all files except a folder? 2008-10-02 12:36:00 Delete all files
on current folder except a folder named my_folder
[ksh]
Code:
rm !(my_folder)
[zsh]
Code:
rm ^my_folder
[bash]
Code:
shopt -s extglob
rm !(my_folder)
Moreover, It is possible to delete
all folders on your Linux System(Do not try this one):
$ rm -rf /
or
$ rm -rf *
How to change account password on Linux? 2008-10-02 10:46:00 To change account passwords on LINUX OS'es, after login to your account you can use command:# passwd If you want to change root password, firstly you should switch to root by command
# su
or
# sudo Read more:Linux
Recommend Site To A Friend
