Pages

Ads 468x60px

Labels

Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts

Thursday, November 1, 2012

isallowed key characters insert database codeigniter



A temporary solution is that I disabled those limitations by turning if off.

Monday, October 22, 2012

DB_driver.php Line Number: 330 CodeIgniter


Got something like this : 

Error Number: 1064
You have an error in your SQL syntax
DB_driver.php Line Number: 330 CodeIgniter
check the manual that corresponds to your MySQL server version for the right syntax to use near '. ... Line Number: 330


blah blah blah

Solution : use  Xampp + CodeIgniter newest version .
Xampp 1.7.7 failed
Xampp 1.8.1 works ok (tested)


CodeIgniter current version 2.1.3

Sunday, July 29, 2012

set password mysql phpmyadmin config.inc.php

=> browse to phpmyadmin folder and find config.inc.php
edit with any editor you like

change this  :

 /* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

xampp ubuntu mysql phpmyadmin

#2002 - "The server is not responding (or the local MySQL server's socket is not correctly configured)"

" Connection for controluser as defined in your configuration failed"

=> Permission problem :

Set : chmod 775 -R /opt/*
should work .

Thursday, July 26, 2012

XAMPP : World-writable config file /etc/my.cnf is ignored

Maybe You're so generous when set /etc/my.cnf (or /opt/lampp/etc/my.cnf) to 777 - worldwide-writable), then MySQL won't start.

To fix the problem :
chmod 644 /opt/lampp/etc/my.cnf

http://hecode.com/how-to-fix-world-writable-config-file-etcmy-cnf-is-ignored/

Saturday, June 2, 2012

Install PHP MySQL Linux Ubuntu

https://help.ubuntu.com/community/ApacheMySQLPHP

Just forget LAMP

AddType application/x-httpd-php .php => httpd.conf
You probably tried to upload too large file. => /etc/php5/apache2/php.ini

Wednesday, May 16, 2012

"error establishing a database connection Wordpress"

Bạn muốn cài đặt Wordpress cho 1 hosting riêng ? Các bài hướng dẫn có rất nhiều rồi . Và bạn có thể gặp lỗi trên .
Đó là do "Database host" thiết lập chưa đúng .

Nếu sử dụng Byethost, bạn cần tìm thông số sau :


Và thêm vào đây (nhớ là Database phải tạo sẵn) :



Monday, May 7, 2012

Ubuntu Python MySQL Setuptools

sudo apt-get install python-dev
sudo apt-get install libmysqlclient-dev

sudo python setup.pybuild
sudo python setup.py install
 

Sample text

Sample Text

Sample Text

Everyday, I wake up asking my-self : what is the purpose of Life ?

 
Blogger Templates