MySQL setup

When you install mysql server, on your system, you need to some basic things so
taht you can seamlessly access it from any other machine.

1) By default, root user is created without password for Mysql server.

2) From Server , you can connect to MySQL Server using commandline mysql client.
using user root

$ mysql -u root -p

do not enter any password.

3) by default, MySQL Server is binded locally because of this you can not access it from other machines.
You need to comment out following in /etc/mysql/my.cnf

#bind-address = 127.0.0.1


4) Still with root, you can not access mysql server from remote machine, solution to this is to create a user with sufficient permissions.

mysql> CREATE USER 'magic'@'localhost' IDENTIFIED BY 'magic123'
-> ;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'magic'@'localhost' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE USER 'magic'@'%' IDENTIFIED BY 'magic123';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'magic'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)


I did this mysql setup for number of times but still everytime I go to following link http://dev.mysql.com/doc/refman/5.1/en/adding-users.html


Disclaimer:
This post is for my own reference.

HOWTO - Apache2 + Subversion + SSL

We wanted to install Subversion which can be accessed using HTTP protocol while searching on google, we got to nice article at

http://www.debuntu.org/2006/05/20/54-how-to-subversion-svn-with-apache2-and-dav

Here are details...


I needed install Apache2 + Subversion and i have searching for info, etc. and now i'm decide to create this tutorial, i hope you like!

Here we go:

INSTALL APACHE2

To install apache2 run that command:
Code:

sudo apt-get install apache2

(if you want also install php and mysql just follow this Link)

After you will install subversion:
Code:

sudo apt-get install subversion

(in that moment doens't exist the pre-buil binary of the last version (1.2.1), but when it's out you can simple upgrade )

To use svn with apache you need install libapache2-svn:
Code:

sudo apt-get install libapache2-svn

Now is better restart apache :
Code:

sudo /etc/init.d/apache2 restart

If you don't want SSL go to the last instructions (dav_svn.conf configurations, and users accounts).

Run:
Code:

a2enmod ssl

Add "Listen 443" to /etc/apache2/ports.conf:
Code:

sudo gedit /etc/apache2/ports.conf

Run:
Code:

apache2-ssl-certificate

Create a new SSL configuration file:
Code:

sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/myown-ssl

Edit myown-ssl file:
Code:

sudo gedit /etc/apache2/sites-available/myown-ssl

Change:
Code:

NameVirtualHost *

to
Code:

NameVirtualHost *:443

and
Code:



to
Code:



Add before :
Code:

SSLEngine on
SSLCertificateFile /etc/apache2/ssl/apache.pem
SSLProtocol all
SSLCipherSuite HIGH:MEDIUM

Run:
Code:

a2ensite myown-ssl

Restart Apache:
Code:

sudo /etc/init.d/apache2 restart

Last instruction:

Edit dav_svn configuration file and follow the instructions:
Code:

sudo gedit /etc/apache2/mods-available/dav_svn.conf

Restart apache:
Code:

sudo /etc/init.d/apache2 restart

Create SVN folder:
Code:

sudo svnadmin create /srv/svn
sudo chown -R www-data:www-data /srv/svn
sudo chmod -R g+ws /srv/svn

Create the users account file:
Code:

sudo htpasswd2 -c /etc/apache2/dav_svn.passwd svnuser

(after asks for a password)

Test SVN:
Code:

svn import .bashrc https://localhost/svn/testfile -mlogentry

That is all!!!


For the SSL instructions i have follow this Tutorial.
About how using SVN see the official SVN book here or visit the official website (Link).

Any error, please report! (and not only in the istructions but also in the english...)

Product FAQ

• Is my product compelling to our target customer?
• Have we made this product as easy to use as humanly possible?
• Will this product succeed against the competition? Not today’s competition, but the competition that will be in the market when we ship?
• Do I know customers that will really buy this product? Not the product I wish we were going to build, but what we’re really going to build?
• Is my product truly differentiated? Can I explain the differentiation to a company executive in two minutes? To a smart customer in one minute? To an industry analyst in 30 seconds?
• Will the product actually work?
• Is the product a whole product? How will customers actually think about and buy the product? Is it consistent with how we plan to sell it?
• Are the product’s strengths consistent with what’s important to our customers? Are we positioning these strengths as aggressively as possible?
• Is the product worth money? How much money? Why? Can customers get it cheaper elsewhere?
• Do I understand what the rest of the product team thinks is good about the product? Is it consistent with my own view?


From SVPG guide