jueves, 22 de agosto de 2013

Where is php.ini located?

The simplest way to find php.ini:

find / -name php.ini

How-To Create A MySQL Database And Set Privileges To A User

Install mysql:

1. apt-get install mysql-server

2. $ mysql -u root -p
Enter password:

3. mysql > create database amarokdb;
Query OK, 1 row affected (0.00 sec)

4.mysql > grant usage on *.* to amarokuser@localhost identified by ‘amarokpasswd’;
Query OK, 0 rows affected (0.00 sec)

5.mysql > grant all privileges on amarokdb.* to amarokuser@localhost ;
Query OK, 0 rows affected (0.00 sec)

6.$ mysql -u amarokuser -p’amarokpasswd’ amarokdb

Source: http://www.debuntu.org/how-to-create-a-mysql-database-and-set-privileges-to-a-user/

Install mysql php ubuntu

Install mysql

$ apt-get install apache2
$ apt-get install mysql-server
$ apt-get install php5
$ apt-get install libapache2-mod-php5
$ apt-get install php5-gd
$ apt-get install php5-dom
$ apt-get install php5-pgsql
$ apt-get install php5-mysql


* Mysql con PHP5

Cómo ver todas las contraseñas guardadas en Chrome

Cómo ver todas las contraseñas guardadas en Chrome

chrome://settings/passwords

Uploading Files With Secure Copy (SCP)

You can upload files to the server using the following syntax:

scp SourceFile user@host:directory/TargetFile

miércoles, 12 de junio de 2013

mysql create utf8 database

mysql create utf8

 database CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

viernes, 7 de junio de 2013

jueves, 6 de junio de 2013

How To Restore MySQL database

How To Restore MySQL database

 # mysql -u root -ptmppassword mysql > create database sugarcrm;
Query OK, 1 row affected (0.02 sec)

 # mysql -u root -ptmppassword sugarcrm > /tmp/sugarcrm.sql

 # mysql -u root -p[root_password] [database_name] > dumpfilename.sql

How To Backup MySQL database

How To Backup MySQL database

backup:

# mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql 

restore:

# mysql -u root -p[root_password] [database_name] > dumpfilename.sql

martes, 4 de junio de 2013

How can I change the default width of a Twitter Bootstrap modal box?

body .modal-admin {
 /* new custom width */
 width: 750px;
 /* must be half of the width, minus scrollbar on the left (30px) */
 margin-left: -375px; }

Entradas populares