I recently installed MySQL on NetWare and have...
Articles and Tips: qna
01 Aug 2003
Q.
I recently installed MySQL on NetWare and have a few questions. Since I am new to using MySQL, please bearwith my questions. Should I create separate SQL server instances with different ports for each users(s) DB or will one instance of the DB do for most light DB applications?
Are there applications available that can be used to create or test DB's on my mySQL server. Most that I have run into have the abilty to connect to most every other DB but MySQL.
I have read many pages of documentation and am still a little unclear as to how to create users for authentication to the MySQL server for our end users. Of course root user is intact but not something I'm willing to just have everyone use.
Am I to assume that most applications that utilize a MS SQL db can also utilize the MySQL with a little massaging or some type of conversion utility?
I noticed that on the MySQL status screen that the IP Address reads 0.0.0.0 and could find nowhere to specify. By default I assume that the instance of MySQL that I start uses the IP addess bound to the server NIC. If this is the case then the only thing I need to have users connect to is the servers IP address and port 3306 (or whatever port). Is this a correct assumption?
Can I use secondary addressing and bind the seconday IP address to the instance and port of MySQL running on my server(s)?
A.
A single server instance of MySQL is usually sufficient. You can create a number of users, each with rights to specific databases. Multiple instances are useful when you want root users in each instance that don't have access to each others data, which gives complete isolation.
There are a number MySQL client tools, both free and pay tools. I have used phpMyAdmin ( http://phpmyadmin.net) and MyCC ( http://www.mysql.com/downloads/mysqlcc.html). You can also try http://www.mysql.com/portal/partners/software/index.html, http://www.mysql.com/portal/software/index.html, or do a search for MSQL client tools on Google. The above tools will help you create users. http://www.mysql.com/doc/en/Adding_users.html (Adding New Users to MySQL) is also very helpful.
The partners and software links above also contain conversion tools from many different databases (including MS SQL) to MySQL. Applications that use ANSI SQL can be moved to MySQL quite easily. MySQL will not support stored procedure until version 5.0, and so you might run into some problems in that area.
'0.0.0.0' is special ip address that maps to the primary ip address on the current machine. This is a default for most applications on NetWare. You can change this value to the actual primary ip address (or a secondary ip address) with the "bind-address" parameter.
* Originally published in Novell AppNotes
Disclaimer
The origin of this information may be internal or external to Novell. While Novell makes all reasonable efforts to verify this information, Novell does not make explicit or implied claims to its validity.