> a. But the mysql does not show any databases when using command > “show databases” in the mysql command prompt.
Are you logged in as root? If not, try it again as the MySQL root user.
i.e.:
$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23440
Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
Also, make sure all the tablespaces and table data have proper
ownership:
sudo chown -R mysql:mysql /var/lib/mysql
If there still aren't any databases visible, I would just reinstall
mysql:
sudo apt-get autoremove mysql-server
sudo apt-get install mysql-server
> Need help on the following:
>
> 3. Actually setting up mysql for remote access
* make sure MySQL allows TCP/IP connections; make "bind-address" the
actual IP of the box or comment it out ( http://tinyurl.com/4ytnyq )
in /etc/mysql/my.cnf
* make sure your firewall allows connections to mysql (port 3306 by
default)
* add remote _non root_ mysql user(s) using the GRANT command
( http://tinyurl.com/7zxhv )
* restart the server ("sudo /etc/init.d/mysql restart")
* check that server is running ok ("sudo /etc/init.d/mysql status")
* check logs for errors ("sudo less /var/log/mysql.err", "sudo
less /var/log/mysql.log")
> 4. Migrating the database from windows to linux. [the already
> sent link for direct copy method has only copy process but does not
> say how to move the same to linux]
* I recommend sending files via SSH/SCP. First, set up the ssh server
(sudo apt-get install openssh-server)
* make sure your firewall allows connections to SSH (port 22 by default)
* on the Windows box, install WinSCP ( http://winscp.net ) and copy over
the files while MySQL is stopped
> I am attaching the document with steps that was sent to us by one of
> the linux experts and that we followed.
I didn't see an attachment.
signature.asc
Description: This is a digitally signed message part
------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge
_______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
