Linux Troubleshooting Make Easy.

Linux Learning & Troubleshooting Make Easy.

MySQL Installation and configuration

Download Red Hat / Fedora Core RPM Packages:

•     mysql-VERSION.i386.rpm (Required)
•     mysql-server-VERSION.i386.rpm (Required)
•     mysqlclient9-VERSION.i386.rpm (Shared object libraries)
•     mysql-devel-VERSION.i386.rpm (C include files and libraries for software developers)
•     php-mysql-VERSION.i386.rpm (For accessing MySQL database from php)





Then Install theses RPM Packages:
#  rpm -ivh mysql-VERSION.i386.rpm mysql-server-VERSION.i386.rpm mysqlclient9-VERSION.i386.rpm

IF instaling newer versions of MySQL from RPM packages obtained from MySQL.com, you must first import and register their public GPG key:
#  rpm --import pubkey_mysql.asc

To configure MySQL to start at boot time, use the chkconfig command:
#  chkconfig mysqld on

You can start, stop, and restart MySQL after boot time using the service commands:
#  service mysqld start/stop/restart

You can test whether the mysqld process is running:
#  pgrep mysqld

The main MySQL configuration file:
#  vi /etc/my.cnf

MySQL databases are usually located at:
#  cd /var/lib/mysql/

Creating a MySQL "root" Account :
#  mysqladmin -u root password <new-password>

To Accessing The MySQL Command Line:
#  mysql -u root -p

To Create a database ( New_database ):
#  mysqladmin -h localhost -u root -p <new-password> create New_database


It is not a good idea to use the root account always because of its universal privileges. So create a MySQL username and password with privileges to access the databases:

LogIn to MySql Command Line :

#  mysql -u root -p
#  grant all privileges on database.* to username@"servername" identified by 'password';
#  flush privileges;


4 comments:

ninest123 Ninest said...

ninest123 11.26
michael kors handbags, burberry factory outlet, longchamp bags, replica watches, louboutin uk, michael kors outlet, uggs outlet, prada handbags, louis vuitton outlet online, cheap oakley sunglasses, ralph lauren outlet, louis vuitton outlet, cheap jordans, louboutin shoes, louis vuitton, gucci handbags, ralph lauren polo, oakley sunglasses, oakley sunglasses, oakley sunglasses, longchamp outlet, ray ban sunglasses, longchamp outlet, nike outlet, ray ban sunglasses, christian louboutin, uggs outlet, prada outlet, nike free, michael kors outlet online, nike air max, ray ban sunglasses, uggs on sale, christian louboutin, nike air max, replica watches, michael kors outlet online, burberry outlet, uggs on sale, tiffany jewelry, louis vuitton handbags, oakley sunglasses, tiffany jewelry, uggs on sale, tory burch outlet, michael kors, louis vuitton outlet, michael kors outlet online

ninest123 Ninest said...

longchamp pas cher, timberland pas cher, polo ralph lauren uk, nike trainers uk, true religion outlet, hermes pas cher, nike roshe run pas cher, nike tn pas cher, michael kors, nike air max pas cher, michael kors uk, abercrombie and fitch UK, north face uk, north face pas cher, mulberry uk, vanessa bruno pas cher, michael kors, lunette ray ban pas cher, sac guess pas cher, longchamp soldes, nike air max uk, coach purses, louboutin pas cher, coach outlet store online, abercrombie and fitch, ralph lauren pas cher, true religion outlet, vans pas cher, hollister uk, nike free pas cher, true religion outlet, nike free, nike air max uk, ray ban uk, jordan pas cher, polo lacoste pas cher, nike blazer pas cher, hogan sito ufficiale, true religion jeans, lunette oakley pas cher, lululemon outlet, nike roshe uk, nike air max, new balance, converse, burberry pas cher, coach outlet, michael kors outlet online, nike air force

ninest123 Ninest said...

iphone 6s cases, mac cosmetics, north face outlet, oakley, vans scarpe, nike air max, hermes handbags, softball bats, ipad cases, s6 cases, louboutin, nike roshe run, gucci, vans outlet, abercrombie and fitch, celine handbags, mont blanc, valentino shoes, iphone 5s cases, ray ban, giuseppe zanotti, lululemon outlet, beats by dre, nfl jerseys, mcm handbags, bottega veneta, nike air max, iphone 6 cases, chi flat iron, insanity workout, iphone cases, converse, asics running shoes, instyler ionic styler, reebok outlet, babyliss pro, hollister clothing, north face outlet, polo ralph lauren, soccer shoes, wedding dresses, salvatore ferragamo, iphone 6 plus cases, new balance shoes, herve leger, iphone 6s plus cases, p90x workout, ghd hair, hollister, timberland boots, jimmy choo outlet, soccer jerseys

ninest123 Ninest said...

louis vuitton, pandora jewelry, moncler, pandora uk, canada goose, canada goose pas cher, barbour jackets uk, moncler, canada goose outlet, hollister, louis vuitton, moncler jackets, replica watches, toms shoes, uggs outlet, moncler, canada goose outlet, ugg pas cher, canada goose uk, lancel, ugg uk, juicy couture outlet, bottes ugg pas cher, converse shoes outlet, thomas sabo uk, karen millen uk, wedding dresses uk, sac louis vuitton, pandora charms, supra shoes, pandora jewelry, barbour, moncler pas cher, coach outlet, moncler outlet, marc jacobs, louis vuitton uk, ugg,uggs,uggs canada, swarovski jewelry, canada goose jackets, canada goose, sac louis vuitton, doke & gabbana, moncler, ugg,ugg australia,ugg italia, montre pas cher, canada goose jackets, swarovski uk, juicy couture outlet, links of london uk, moncler uk
ninest123 11.26