Re: Help on Debian Source building mysql 5.5.10 w/ CMake

[Noel Cruz]

starting the mysql server from exe compiled 5.5.10 source is ? tested the compiled client exe from source surprisingly works. i can remote login from a working msi installed windows xp/vista mysql server 5.5.10. so setup is mysql server on windows and perl/php/apache on windows.

noel

part terminal output:
okkaba@okako:~$ ping 192,168.1.75
ping: unknown host 192,168.1.75
okkaba@okako:~$ ping 192.168.1.75
PING 192.168.1.75 (192.168.1.75) 56(84) bytes of data.
64 bytes from 192.168.1.75: icmp_seq=1 ttl=128 time=3.53 ms
64 bytes from 192.168.1.75: icmp_seq=2 ttl=128 time=0.093 ms
64 bytes from 192.168.1.75: icmp_seq=3 ttl=128 time=0.093 ms
64 bytes from 192.168.1.75: icmp_seq=4 ttl=128 time=0.087 ms
64 bytes from 192.168.1.75: icmp_seq=5 ttl=128 time=0.094 ms
64 bytes from 192.168.1.75: icmp_seq=6 ttl=128 time=0.090 ms
64 bytes from 192.168.1.75: icmp_seq=7 ttl=128 time=0.090 ms
64 bytes from 192.168.1.75: icmp_seq=8 ttl=128 time=0.096 ms
64 bytes from 192.168.1.75: icmp_seq=9 ttl=128 time=0.092 ms
64 bytes from 192.168.1.75: icmp_seq=10 ttl=128 time=0.090 ms
^C64 bytes from 192.168.1.75: icmp_seq=11 ttl=128 time=0.097 ms
64 bytes from 192.168.1.75: icmp_seq=12 ttl=128 time=0.095 ms
64 bytes from 192.168.1.75: icmp_seq=13 ttl=128 time=0.099 ms
64 bytes from 192.168.1.75: icmp_seq=14 ttl=128 time=0.097 ms
64 bytes from 192.168.1.75: icmp_seq=15 ttl=128 time=0.112 ms
64 bytes from 192.168.1.75: icmp_seq=16 ttl=128 time=0.100 ms
64 bytes from 192.168.1.75: icmp_seq=17 ttl=128 time=0.092 ms
64 bytes from 192.168.1.75: icmp_seq=18 ttl=128 time=0.100 ms
64 bytes from 192.168.1.75: icmp_seq=19 ttl=128 time=0.101 ms
64 bytes from 192.168.1.75: icmp_seq=20 ttl=128 time=0.098 ms
^C
--- 192.168.1.75 ping statistics ---
20 packets transmitted, 20 received, 0% packet loss, time 19005ms
rtt min/avg/max/mdev = 0.087/0.267/3.538/0.750 ms
okkaba@okako:~$ cd /usr/local/mysql/bin/
okkaba@okako:/usr/local/mysql/bin$ mysql -h 192.168.1.75 -p -u sampadm1
bash: mysql: command not found
okkaba@okako:/usr/local/mysql/bin$ ./mysql -h 192.168.1.75 -p -u sampadm1
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.5.10 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SELECT NOW(), USER(), VERSION()\G
*************************** 1. row ***************************
NOW(): 2011-04-06 13:23:21
USER(): sampadm1@unodos
VERSION(): 5.5.10
1 row in set (0.00 sec)

mysql> USE sampdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT last_name, first_name FROM president WHERE last_name='roosevelt';
+-----------+-------------+
| last_name | first_name |
+-----------+-------------+
| Roosevelt | Theodore |
| Roosevelt | Franklin D. |
+-----------+-------------+
2 rows in set (0.00 sec)

mysql> quit
Bye
okkaba@okako:/usr/local/mysql/bin$ ./mysql -h 192.168.1.75 -p -u sampadm1 sampdb
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.5.10 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye
okkaba@okako:/usr/local/mysql/bin$