Skip to main content

FAMPP - Installing MySQL Server

simpler command :)

#pkg_add -r mysql51-server

from this command it will install mysql server and also mysql client for the server

once done we can enable it on boot up by editing rc.conf

#ee /etc/rc.conf

add this following line

mysql_enable="YES"

After that we can start the service by this command :

#sh /usr/local/etc/rc.d/mysql-
server.sh start

Then we have to configure our root login for mysql which is by default it is blank. By using a password for the root login it will be more safe to outsider :)

#mysql -u root
#SET PASSWORD FOR 'root'@'localhost' = PASSWORD('urpasswordhere');

once done try to login using root user

#mysql -u root -p
Enter password:

If that appear then you have successfully configuring your mysql server :)
Labels:

Comments

Post a Comment

Popular posts from this blog

MySQL Enterprise thingy

It's been a weird thing when you install MySQL server especially the one that is 'enterprise' version is not working with your PHP. That is the problem that my friend and I facing today. Since PHP require php-mysql extension to connect to MySQL server but php-mysql is only work with mysql-server from the Repos (Redhat/Centos). 1) Remove default mysql-server/php-mysql 2) Install MySQL Enterprise 3) Dependencies conflict occur + headache + install php-mysql shell> yum install php-mysql Loaded plugins: rhnplugin, security Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package php-mysql.x86_64 0:5.1.6-27.el5 set to be updated --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: php-mysql --> Processing Dependency: libmysqlclient.so.15()(64bit) for package: php-mysql --> Running transaction check ---> Package mysql.x86_64 0:5.0.77-4.el5_4.2 set to be updated --> Process...
2 comments
Read more

DirectAdmin - Upgrading MySQL from 5.5 to 5.6

cd /usr/local/directadmin/custombuild mkdir -p mysql cd mysql wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-client-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-devel-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-server-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-shared-5.5.41-1.linux2.6.x86_64.rpm cd .. ./build mysql_backup mv mysql_backups mysql_backups.`date +%F` #after this point, you can't abort rpm -e --noscripts `rpm -qa | grep MariaDB` cd mysql rpm -ivh MySQL*5.5.41*.rpm #ensure it's running. cd .. ./build set mysql 5.6 ./build set mysql_inst yes ./build mysql # confirm mysqld is running. ./build php n
Post a Comment
Read more

Masalah unetbootin di Mac untuk USB boot

Masalah unetbootin kadang jadi kadang tidak, so solution yang cepat ialah gunakan dd. Kenal pasti USB disk kita dia mac dengan arahan : Yusof$ diskutil list /dev/disk0 (internal, physical):    #:                       TYPE NAME                    SIZE       IDENTIFIER    0:      GUID_partition_scheme                        *240.1 GB   disk0    1:                        EFI EFI                     209.7 MB   disk0s1    2:          Apple_CoreStorage Macintosh SSD           239.2 GB   disk0s2    3:                 Apple_Boot Rec...
Post a Comment
Read more