Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 9

Displaying posts with tag: Help Desk (reset)

How To – Configure MySQL to Use UTF-8
+1 Vote Up -1Vote Down

Background Knowledge


Using the character set UTF-8 allows for the use of any language, can represent every character in the Unicode character set and is backward compatibility with ASCII. Not to mention is can handle any platform and be sent through many different systems without corruption. With such advantages this is why so many are making the switch.

The following instructions were done on Debian Squeeze v6.04 AMD64 operating system using MySQL v14.14 Distrib 5.1.61.

Solution – Server Configuration


At present MySQL is configured by default to use “latin1″ character set. Here’s how to change MySQL configuration to use UTF-8 character set and collation.

  • Check MySQL’s current configuration, run the following two SQL statements.
    1
    2
    
    SHOW VARIABLES LIKE '%collation%'; 
    SHOW
  •   [Read more...]
    How To – Fix MySQL Option Without Preceding Group
    +0 Vote Up -0Vote Down

    Background Knowledge


    You try starting, stopping or connecting to MySQL and receive the following error, “Error: Found option without preceding group in config file: /etc/mysql/conf.d/char_collation_set.cnf at line: 1″. The error message my vary but comes to the same issue. MySQL may not start or might experience connectivity issues.

    This issue was experienced on Debian Squeeze v6.04 AMD64 system with MySQL v14.14 Distrib 5.1.61.

    Solution


    This issue is caused by a improperly formatted MySQL configuration file(s) and refers to one missing the group heading (e.g. [mysqld], [mysqld_safe], etc.).

    Source:   [Read more...]

    How To – Find The Version of Shockwave/Flash Player Installed
    +0 Vote Up -8Vote Down

    The following links load a flash file that will report what version is installed for Adobe Flash and Adobe Shockwave.

    Source: Version test for Adobe Flash Player

    Source: Test Adobe Shockwave & Flash Players

    Windows Vista SP1 – Explorer Not Refreshing CD/DVD Drives
    +0 Vote Up -0Vote Down

    Background Knowledge


    I have Windows Vista Ultimate with Service Pack 1 with the following optical media drives. The system is approximately one year old.

    • Manufacture: LG
    • Model: HL-DT-STDVD-ROM_GDRH20N
    • Firmware version: 0D04
    • Manufacture: LG
    • Model: HL-DT-ST DVD+-RW GSA-H73N
    • Firmware version: B103

    Problem


    There are two issues I’m experiencing all resulting in the fact that windows explorer is not refreshing the drive contents and/or drive volume label. Both issues occur on CD/DVD reader and CD/DVD writer drives. As well I’ve tried multiple discs from ones I’ve burnt to discs that were commercial produced and these discs all work fine on other computer systems.

  • My Computer/Windows Explorer is not refreshing
  •   [Read more...]
    How To – Resolve Adobe PDF Printer is Not Bound to Adobe PDF Port
    +0 Vote Up -0Vote Down

    Background Knowledge


    I have Windows Vista with Adobe Acrobat Professional v8.1.3 installed and I was trying to covert to Adobe PDF within Microsoft Publisher 2007.

    Error Message


    Acrobat PDFMaker reported the following error message dialog, “Adobe PDF Printer is not bound to Adobe PDF Port. Cannot proceed further. Kindly change the PDF Port to Adobe PDF Port in Adobe PDF Printer Settings”.

    Solution


  • Go to Control Panel -> Printers.
  • Right mouse click on “Adobe PDF” and left click on “Properties”.
  • Left mouse click on
  •   [Read more...]
    Apache Warning - MySQL Lib Size Mismatch Solution
    +0 Vote Up -0Vote Down

    I was having some problems with my web site so I went off to check my Apache HTTPD error_log and found three warning messages logged.

    Apache HTTPD error_log
    /usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(client_errors) size mismatch, relink your program
    /usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(default_directories) size mismatch, relink your program
    /usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(globerrs) size mismatch, relink your program

    After some time of research and with no solution, I decided to mention the problem in Midgard




      [Read more...]
    Apache Warning - MySQL Lib Size Mismatch Solution
    +0 Vote Up -0Vote Down

    I was having some problems with my web site so I went off to check my Apache HTTPD error_log and found three warning messages logged.

    Apache HTTPD error_log
    /usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(client_errors) size mismatch, relink your program
    /usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(default_directories) size mismatch, relink your program
    /usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(globerrs) size mismatch, relink your program

    After some time of research and with no solution, I decided to mention the problem in Midgard IRC channel. With




      [Read more...]
    PEAR: Command Not Found
    +0 Vote Up -0Vote Down

    I recently installed PHP 4.3.11 from source (due to configuration requirements) on to an OpenBSD i386 v3.7 server. The installation went perfectly as it has many times before, however I found out that the PEAR script was not installed (normally in /usr/local/bin). I discovered this when trying to install some pear packages doing “pear install packagename”. I get a returned error of “-bash: pear: command not found”. I tried locating the PEAR script using “find / -name pear” and “/usr/libexec/locate.updatedb” then “locate -i pear”. The result came up empty with no PEAR script in the returned results. I double checked the PEAR documents, PHP documents and ./configure all three places stated PEAR is installed by default unless a parameter is provided at configure with

      [Read more...]
    PEAR: Command Not Found
    +0 Vote Up -0Vote Down

    I recently installed PHP 4.3.11 from source (due to configuration requirements) on to an OpenBSD i386 v3.7 server. The installation went perfectly as it has many times before, however I found out that the PEAR script was not installed (normally in /usr/local/bin). I discovered this when trying to install some pear packages doing “pear install packagename”. I get a returned error of “-bash: pear: command not found”. I tried locating the PEAR script using “find / -name pear” and “/usr/libexec/locate.updatedb” then “locate -i pear”. The result came up empty with no PEAR script in the returned results. I double checked the PEAR documents, PHP documents and ./configure all three places stated PEAR is installed by default unless a parameter is provided at configure with –without-pear. I’m still not aware as

      [Read more...]
    Showing entries 1 to 9

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.