(Answer) (Category) NetMAXFAQ : (Category) Advanced Configuration :
How do I get started using MySQL?
Applies to: NetMAX version 4.0x
address-suppressed
To get started using the MySQL database server that is installed with NetMAX 4.x products, you will first need to start the MySQL server with the following command:

/etc/rc.d/init.d/mysqld start

You will also want to run this command, so that MySQL is started and stopped properly at the appropriate run levels when rebooting.

/sbin/chkconfig --level 345 mysqld on

The next step is to set your root MySQL password with the following:

/usr/bin/mysqladmin -u root password mypass

(Where mypass is the password that you want to use.)

That's it. You can now use the usual MySQL commands to access your MySQL database server. We have also compiled PHP with MySQL support and included Perl::DBI and Perl::DBD::mysql so that you can get started using the MySQL server with CGI.

For more information and full documentation on the MySQL server, please visit the official MySQL web site

NOTE: If you previously had MySQL installed on your NetMAX, you will want to remove the MySQL user and group that you had created in the NetMAX Interface, before upgrading to NetMAX 4.0. After the upgrade, you'll need to chown your database files to the new mysql user and group. If you had previously installed your database files in the default /var/lib/mysql directory, you can use this command:

chown -R mysql:mysql /var/lib/mysql

address-suppressed
Previous: (Answer) How do I automate the processing of my Traffic Monitor Report.
Next: (Answer) How do I delete the partitons on a secondary hard disk with NetMAX?
This document is: http://www.netmax.org/cgi-bin/fom.cgi?file=469
[Search] [Appearance]
This is a Faq-O-Matic 2.721.
This FAQ administered by ...Cybernet Systems Corp.