Pages

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

Sunday, September 24, 2006

MySQL Front discontinued

I was surprised to see on Mysql-Front website this announcement:
MySQL-Front has been discontinued since MySQL AB forced us to remove this program from the market. Thanks a lot for all your help! Your MySQL-Front Team We hope the humanity will learn to work together instead of fighting another senseless...
Getting curious about this started to search on google... Lenz Grimmer clarified this for me:
Clarification: MySQL AB did not force the removal of MySQLFront Our web team informed me that we received a few comments from users about MySQL AB supposedly shutting down the development of the MySQLFront utility. I'’d just like to clarify that this was not the case at all we merely asked the developers to stop violating our trade mark as outlined in our Trade Mark Policy. As I wrote some time ago, our trade marks are a very important asset to us as a company and we need to take action, if our marks are being violated. We did not ask or force them to stop the development or to remove the program from the market completely– this was their very own decision. In fact, we actually encouraged them from the beginning of our discussion to continue the development of the product under a different name. The problem appeared resolved as the project was renamed to SQLFront and the old web site pointed to the new location - we regret that the developers decided to shut down the entire project shortly afterwards. We encourage and support every application that broadens the MySQL Ecosystem. Why would we want to completely shut off applications that support us?
Lenz Grimmer works MySQL AB as a member of the community relations team. The MYSQL AB Trademark policy provides the information related to authorized use of MySQL AB marks. The "problem" is caused by the usage of MySQL as a part of a commercial product name, that is not developed by MySQL. I still don't understand why they shut down the project and communicated that kind of message... Lack of funds and they found a way to close it and blame someone else? /Later edit MySQL Front development continues at Sourceforge under a new name HeidiSQL

Sunday, February 06, 2005

Securing a MySQL Server on Windows

Many users that install mysql database server, skip the process necesary for securing it. There are many users that still allow root login from any host (%), maybe still have a valid user login with no password. Here is an article from MySQL about Securing a MySQL Server on Windows

How to install and configure your own web server

Install Apache2, PHP 4.3.10 and MySQL

Here is a quick tutorial to make your own web server [Apache, PHP4, MySQL] on Windows. Of course you can always download an already made server suite, but all you do next, next, next... and then edit your php scripts. Installing your own web server and configuring it will improve your knowledge in this field, and gives you the oportunity to configure it for your own needs. Download [latest stable realeses]: Apache [httpd-2.0.52-win32-x86-src.zip] PHP PHP 4.3.10 zip package MySQL 4.1.9 [I still use MySQL 3.23] Create a folder on your disk C:\www Run apache installer:
- install location c:\www
[default c:\program files\apache group]:
so it will install c:\www\apache2
- Hostname: localhost or your IP address
- Listen: 80
- admin email address: youremail@address.com
- finalize install
Create the folder: c:\www\htdocs Unzip php-4.3.10-Win32.zip to c:\www\php4 Copy [or cut] c:\www\php4\sapi\* to c:\www\php4\* Rename php.ini-dist to php.ini and edit it:
; The root of the PHP pages, used only if nonempty.
; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
; see documentation for security issues.  The alternate is to use the
; cgi.force_redirect configuration below
doc_root = c:/www/htdocs
;...........................
extension_dir = "c:/www/php4/extensions"
; Uncoment eny extension that you may need
extension=php_xslt.dll
;............... display all error except notices
error_reporting  =  E_ALL & ~E_NOTICE
;displaying script errors:
display_errors = On
; if you are using for production is it recommended to be set to Off

Note: php_xslt.dll requiers sablot.dll [placed under %WINDIR%\system32] php_exif requires php_mbstring.dll loaded BEFORE. For other extensions check documentation first. Copy php.ini in your %WINDIR% directory [that is c:\windows or c:\winnt] Configure apache to handle php scripts: Open and edit c:\www\apache2\conf\httpd.conf
ServerRoot "C:/www/Apache2"
#....edit
Listen 80
#.....ad the line
LoadModule php4_module /www/php/php4apache2.dll
#....edit
ServerName localhost:80
#...edit
DocumentRoot "C:/www/htdocs"
#...edit
DirectoryIndex index.html index.php default.php index.html.var
#add the lines:
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
Save it and restart Apache [Apache Monitor->Apache2->Restart]. MySQL: Unzip mysql to c:\www\mysql and run c:\www\mysql\bin\winmysqladmin.exe, set root password and you will have mysql databaser server running. I also recommend phpMyAdmin for querying and administering mysql server. Now testing instalation: create a file index.php in c:\www\htdocs and put the following content: <? phpinfo(); ?> then open your browser and go to: http://localhost/ and you should see:

PHP Version 4.3.10 ....

If not, well there is a problem. Send me an email and I will try to help you. Hope this can help... This is mainly the way I've done it several times and it worked on Windows 2000, windows xp, sp2, and last evening was running on windows media center 2005. I also installed mod-python, but that will be another post :)