Eager to Code, Enjoy to Debug ~ Embark into Each Stage with Your Heart

Archive for the ‘MySQL’ Category

Configuring MySQL without Password on Ubuntu

Posted by: Chyne on: November 3, 2009

Everytime when I access to mysql database that is installed in my laptop, I need to perform the following command in order to get the access:

sudo mysql -hlocalhost -ppassword

I feel frustrated and tedious to do that everytime when I need to access to the database. If I try it with the command ‘mysql’, I will [...]

Installation of Bugzilla in Ubuntu Environment

Posted by: Chyne on: August 4, 2009

I’ve been playing around with the Bugzilla in order to understand how it works together with the system. I was being provided with the information about the flow of how to migrate the bug issues to the system but there are no detailed instructions on how to install Bugzilla. Although the main point is not [...]

Recently there is a reported issue regarding with the MySQL database that throws the SQL exception of converting values to timestamp:

(SQL Exception while getting value: (Cannot convert value ‘0000-00-00 00:00:00′ from column 15 to TIMESTAMP.))

At the beginning, I’m not sure what is the problem with the conversion and I really have no idea why [...]

After I had resolved the problem of ‘Address already in use’, another error message appeared in the console. The error message is ‘Can’t create/write to file ‘C:\WINDOWS\TEMP\#sql_12a8_0.MYI’.
It took me several hours until I figured out the solution which I never expected it will be that straightforward. I just need to disable the ‘On-access scan’ of [...]

PHPMySqlAdmin Setup

Posted by: Chyne on: September 18, 2008

Apache2 Configuration

In the /conf/httpd.conf, add or configure the following statements:-
• LoadModule php5_module C:/PHP504/php5apache2.dll
• AddType application /x-httpd-php .php
• DirectoryIndex index.html, index.html.var, index.php
Copy the phpMyAdmin folder in the Apache2\htdocs

* Downloaded from: http://httpd.apache.org/
PHP504 Configuration

php.ini-dist configuration:
; Windows: “\path1;\path2”
; include_path:”.;c:\php\includes”
Add C:\PHP504 in the System Environment Path

* Downloaded from: http://www.php.net/downloads.php
PHPMySqladmin Configuration

config.inc
• $cfg[‘PmaAbsoluteUri’]=’http://127.0.0.1/mysqladmin/’;
• $cfg[‘Servers’][$i][‘host’]=’localhost’;
• $cfg[‘Servers’][$i][‘auth_type’]=’cookie’;
• $cfg[‘Servers’][$i][‘user’]=’root’;
• $cfg[‘Servers’][$i][‘password’]=’password’;
Restart the Apache2 in the Services everytime the config.inc has been changed.

Downloaded from: http://www.phpmyadmin.net/home_page/index.php


Friday’s Java Snack


In Java, "thread" means:

  • An instance of class java.lang.Thread
  • A thread of execution


An instance of Thread is just an object that has variables and methods, and lives and dies on the heap.
 
A thread of execution is an individual process that has its own call stack (one thread per call stack).

 

November 2009
M T W T F S S
« Oct    
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Archives


  • Polprav: Hello from Russia! Can I quote a post in your blog with the link to you?
  • Alex: Huge Thanks! This bug has annoyed me for a long time.
  • Donnieboy: Just wanted to drop you a line to say, I enjoy reading your site. I thought about starting a blog myself but don't have the time. Oh well maybe one

StatCounter

free hit counters