Databases

From Mandriva Community Wiki

Mysql

Install Mysql

Open a konsole
su
password
urpmi mysql

Start Mysql

Open a konsole
su
root password
service mysqld start

Configure and secure Mysql

Start Mysql and type:

 
/usr/bin/mysql_secure_installation

Since you have no password for the root user yet, press ENTER at the first prompt to create one.
Type in your password
Confirm your password

After that you can safely answer yes to every prompt:

By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment.

... Remove anonymous users? [Y/n] y

... Success!

Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network.

-n Disallow root login remotely? [Y/n] y

... Success!

By default, MySQL comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment.

-n Remove test database and access to it? [Y/n] y

- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!

Reloading the privilege tables will ensure that all changes made so far will take effect immediately.

-n Reload privilege tables now? [Y/n] y

... Success!

Install Phpmyadmin

• Just install it via the Mandriva Software Manager.
• Phpmyadmin requires a working web server, like Apache, and the PHP scripting language implementation. It might be better to install task-lamp-php all at once to assure that the Linux-Apache-MySQL-PHP (LAMP) stack is in place.
• Go to http://localhost/phpmyadmin and type in "root" as user and the password you provided during the mysql_secure_installation.

Caution !
Mysql and task-lamp-php must be installed before you install phpmyadmin .

Oracle On Mandrake

Installing Oracle 9i On Mandrake Linux 8.1 | UtilsUoracle9 (Contribution, May 14, 2002)

David Stevenson describes how to get Oracle8i release 2, version 8.1.6 installed on Mandrake 8.0

Index, UtilsUoracle0, Oct. 05, 2001

Introduction, UtilsUoracle1, Sep. 14, 2001

Starting Off, UtilsUoracle2, Oct. 05, 2001

Pre-Install, UtilsUoracle3, Sep. 14, 2001

Installing Oracle, UtilsUoracle4, Sep. 14, 2001

Other Sources, UtilsUoracle5, Oct. 05, 2001

Oracle 10g Express How To - Mandrake 2006 PowerPack

GUI Install Instructions for Oracle 10g Express on Mandriva 2006 PowerPack

Install Oracle 10g Express on Mandrake 2006 PowerPack

• Oracle 10g Express may also be referred to as Oracle XE or oracle-xe. To install Oracle 10g Express, you must install the packages "bc" and "libaio1" (libaio1 is available from updates).

• # urpmi bc libaio1

• Install the downloaded Oracle 10g Express package.

• # urpmi oracle-xe-10.2.0.1-1.0.i386.rpm

• You might see some errors in the Oracle pre-install (%pre) scripts, although pre-installing the package "bc" should address most of these.

Oracle 10g Express Requirements

The Oracle web site describes the system requirements. Oracle-XE will refuse to install if your disk space, memory footprint and swap doesn't meet Oracle's requirements. You'll also be asked for a password for the system user.

Starting Oracle 10g Express

• # service oracle-xe start

Starting Oracle Net Listener. Starting Oracle Database 10g Express Edition Instance.

• If you run "ps ax | grep xe", you'll see a number of processes running.

• If you want the service to run at boot, be sure to enable this:

• # chkconfig --add oracle-xe

Using Oracle 10g Express - Command Line/Web Interface

If you're familiar with Oracle, the command-line sqlplus is available. Oracle-XE is the web interface, which allows you to access all of the features, as well as create database applications in a graphical environment. After installing, and starting Oracle 10g Express, the web-interface is available at:

http://127.0.0.1:8080/apex/

Login initially as the "system" user and enable some user accounts or the sample "HR" account. Within Oracle 10g Express there are links to documentation and tutorials that will quickly get you started in creating a simple application using the web interface.

Wiki Home - MySql Web Site - Oracle Web Site - Oracle Enterprise Linux Web Site