A temporary solution is that I disabled those limitations by turning if off.
Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts
Thursday, November 1, 2012
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
Labels:
CodeIgniter,
MySQL,
Xampp
Monday, September 24, 2012
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 :
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;
Labels:
Config,
MySQL,
Password,
PHPmyadmin,
Ubuntu
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 .
" Connection for controluser as defined in your configuration failed"
=> Permission problem :
Set : chmod 775 -R /opt/*
should work .
Labels:
Linux,
MySQL,
PHPmyadmin,
Ubuntu,
Xampp
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 :
To fix the problem :
chmod 644 /opt/lampp/etc/my.cnfhttp://hecode.com/how-to-fix-world-writable-config-file-etcmy-cnf-is-ignored/
Sunday, June 3, 2012
MySQL change default root user password
default : root/"" (blank password)
http://www.cyberciti.biz/faq/mysql-change-root-password/
http://www.cyberciti.biz/faq/mysql-change-root-password/
Labels:
MySQL,
PHPmyadmin
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
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 :
Đó 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-devsudo apt-get install libmysqlclient-dev
sudo python setup.pybuildsudo python setup.py install
Friday, May 4, 2012
Subscribe to:
Posts (Atom)