How to connect MySQL Database on Linux with command


If you want to connect MySQL database on linux apply the following commands;

[root@server~]# mysql -h localhost -u root -pPassword
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is —
Server version: — MySQL Community Server (GPL)

Copyright (c) 2000, 2011, 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>use yourDataBaseName;

Database changed
mysql> truncate table anyTables;

How to start MySQL Database on Linux


You can use the following commands if you want to start,stop or restart MySQL Services on Linux;

[root@server ~]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@server ~]# /etc/init.d/mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@server ~]# /etc/init.d/mysqld start
Starting mysqld:                                           [  OK ]

How to access Linux Partitions from Windows (Vista OS) Operating Systems


If you need to access your Linux EXT3 partitions on Vista OS system with full write and read access first you should download the Ext2Fsd Project software on your computer.

By using Ext2Fsd software, you can access Linux partitions and modify the content of these partitions.

You can download the program from the following link;

http://sourceforge.net/projects/ext2fsd/files/

After installing the program you will see a GUI such as the following one;

From that screen; you should first start the Services for accessing these Linux partitions.

Go to the partition you want to access and right click on it and click Service Management from the menu.

On this menu, you should click Start button for starting the partition access and click Apply button.

(You may need to right click and choose Change Driver Letter option from the menu to assign a drive letter for the Linux partition.)

After that operation, you can access these partitions from the Windows Explorer (You should use the driver letters assigned.) and you will have both read and write access on these Linux partitions.

There are other alternatives for accessing  Linux OS partitions from Windows OS such as the following programs.

DiskInternals Linux reader http://www.diskinternals.com/linux-reader/

Explore2fs  http://www.chrysocome.net/explore2fs


How to configure Oracle Express Edition 10g’s port number, password and start options during boot on Linux OS


If you want to change the port number for Oracle Express Edition DB on Linux OS apply
the following command

[root@localhost ~]# sudo /etc/init.d/oracle-xe configure

Oracle Database 10g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 10g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:8080

Specify a port that will be used for the database listener [1521]:1521

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:N

Starting Oracle Net Listener…Done
Configuring Database…Done
Starting Oracle Database 10g Express Edition Instance…Done
Installation Completed Successfully.
To access the Database Home Page go to “http://127.0.0.1:8080/apex&#8221;

How to edit grub.conf file using vi editor on Linux


Sometimes you need to edit grub.conf file for changing the behaviour of Linux systems start up

To change that file, you should apply the following commands for editing grup.conf file

1. Open a terminal

2. apply the following commands

[tuna@localhost ~]$ su –

Password: type password

[root@localhost ~]# vi /boot/grub/grub.conf

# grub.conf generated by anaconda

#

# Note that you do not have to rerun grub after making changes to this file

# NOTICE: You have a /boot partition. This means that

# all kernel and initrd paths are relative to /boot/, eg.

# root (hd0,1)

# kernel /vmlinuz-version ro root=/dev/sda5

# initrd /initrd-version.img

#boot=/dev/sda

default=1

timeout=5

splashimage=(hd0,1)/grub/splash.xpm.gz

hiddenmenu

title Fedora (2.6.27.5-117.fc10.i686)

root (hd0,1)

kernel /vmlinuz-2.6.27.5-117.fc10.i686 ro root=UUID=4e7e082f-78cf-42e2-8842-3dbb4146245d rhgb quiet

initrd /initrd-2.6.27.5-117.fc10.i686.img

title Other

rootnoverify (hd0,0)

chainloader +1

~

~

~

~

~

~

~

~

~

~

“/boot/grub/grub.conf” 20L, 684C

press i here for inserting (INSERT Mode) (changing the grub.conf file)

default attribute of this file should be modified for selecting the default Operating System. In this situation default:1 will start Vista OS first and if I change it to default=0 then Linux(Fedora) operating system will be started first. I can also change the timeout attribute and this will change waiting period in seconds for the boot menu when the computer starts.

After changing grub.conf you should press ESC (Command Mode) first and press : (colon) after

and w(rite) and q(uit) if you need modification

like :wq or just :q if you need no modification on the file