mysql on Ubuntu

mysql -h 192.168.50.93 -P 3307 -u legui -p     (warning, you need "-p")

mysql --host 192.168.0.145 --port 3307 --user=search_wip -pxxxxxxxx

show databases 

use xx

Install
sudo apt-get install mysql-client
sudo apt-get install mysql-server
Add this source to your sources.list:
deb http://security.ubuntu.com/ubuntu hardy-security main
do an apt-get update



If the mysql runs on 192.168.0.11
sudo vi /etc/mysql/my.cnf
then
# skip-external-locking
bind-address = 192.168.0.11

it prints this at restart:
* Checking for corrupt, not cleanly closed and upgrade needing tables.
It is not an error, it just says that "mysql is" Checking for...

to start
sudo /etc/init.d/mysql start
(don't forget the sudo, otherwise it fails and not very explicit in the error)

Enable firewall mysql ports to be open using
sudo firestarter
or if the server doesn't have kde
sudo /sbin/iptables -A INPUT -i eth0 -s 192.168.0.20/24 -p tcp --destination-port 3306 -j ACCEPT

If running a jdbc access from the same machine on Ubuntu, do this first
mysql -u root -p
mysql> GRANT ALL ON GG.* TO 'root'@'192.168.0.11';
or
mysql> GRANT ALL ON test.* TO 'root'@'192.168.0.11' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> commit;
From phpmysql, you should see a user with the following privileges:
root 192.168.0.11 global ALL PRIVILEGES Oui

You can then connect through DbVisualizer (not putting the db name yet). You can then create the db
mysql> CREATE DATABASE GG;
mysql> CREATE TABLE j_2 ( Id int AUTO_INCREMENT PRIMARY KEY, Date Date, Myint integer, Url varchar(255) );
mysql> commit;
etc

log
/var/log/mysql/mysql.log

helpful
SHOW DATABASES;
SHOW GRANTS FOR 'root'@localhost;
SELECT * FROM j_3 INTO OUTFILE '/toto.txt';

Note: This one is a good post:
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

To use phpmyadmin
you need a root password:

mysql -u root

>UPDATE mysql.user SET Password=PASSWORD('admin') WHERE User='root'
>FLUSH PRIVILEGES;

Also, don't forget to create the link
sudo ln -s /usr/share/phpmyadmin/ phpmyadmin

/var/www/phpmyadmin/libraries$ vi config.inc.php
$cfg['PmaAbsoluteUri'] = 'localhost/phpmyadmin/';
$cfg['Servers'][$i]['host'] = '192.168.0.5';
$cfg['Servers'][$i]['password'] = 'mypassword';

Also, you may want to add the line (it seems it is 3600 sec by default)
/etc/phpmyadmin$ vi config.inc.php
$cfg['LoginCookieValidity'] = 10000000;

About export/import
Export:
mysql -u root -p
mysql> use test
mysql> select * from jg_seeds_3 INTO OUTFILE '/tmp/jg_seeds_3.txt'
Import:
$ sudo mysqlimport -u root -p GG /tmp/jg_seeds_3.txt
-> password (mysql pw)
Please note that the file base name jg_seeds_3 has to match the table name in GG. The file extension (txt here doesn't matter). Put the input file in /tmp since mysql user has all privileges on the folder and all its parents.

mysql dump

dump:
mysqldump -h bo-sql-lb-master.be.p1.canon -u bill -p --max_allowed_packet=1073741824 --lock-tables=false stats_fr tb_popu > popu-all.sql
load:
mysql -h hostname -u user --password=password databasename < filename

Fedora admin survival kit

Network config
/usr/bin/system-config-network

/etc/rc.d/init.d/
/etc/sysconfig/network

files in /etc/sysconfig/network-scripts/*

Upgrade from Fedora 5 to Fedora 10:
I get the error: Error enabling swap device hdb3: No such file or directory
The /etc/fstab on your upgrade partition does not reference a valid swap partition.

What I did is rename hdb3 by sdb3 in fstab. Then the install worked fine.
After that, I had to change in /etc/X11/xorg.conf: Driver "i810" to Driver "vesa"

After that I start having applications that crashed with different errors. I started to be tired of this upgrade, I decided to re-install totally. The Fedora10 installer froze when it asked me for license, no keyboard, mouse inactive (eventhough it was active in the first screen of the installer). I said OK, let's give Ubuntu a try... Using Ubuntu 8.04 I finally could install without issue, no video configuration to change, no application crashing, Ubuntu works for me.

free.fr

PagePerso propose MySql and PostgreSQL but these have to be used from the free.fr server, cannot be accessed directly from the outside.

When using the db url jdbc:postgresql://sql.Free.fr/esicdtek:5432
it seems it is not using the server name at all

if you want to put a public machine on your personal freebox LAN, I recommend putting the public machine on your main subnet and using a new router to create a subnet with all the other machines. See
http://www.sangoma.com/support/tutorials/tcp_ip.html

SSII

Regie: Délégation de personnel chez le client

Forfait: Projets que la SSII traite chez elle

Infogerence: cas particulier d'outsourcing, correspond aussi bien à la maintenance du parc, qu'à la gestion de projets, qu'à la sécurité informatique et même aux formations.