How to Create a New User In Part 1 of the MySQL Tutorial, we did all of the editing in MySQL as the root user, with full access to all of the databases. However, in the cases where more restrictions may be required, there are ways to create users with custom permissions. Let’s start by […]
As MySQL 5.1 is standard in CentOS/RHEL 6.x, it is not included in the Webtatic EL 6 repository. Install Atomic Yum Repository On CentOS Linux: [root@test]# wget -q -O – http://www.atomicorp.com/installers/atomic |sh then install yum install mysql55 mysql55-server
Copied from: http://brennan.id.au/20-Shared_Address_Book_LDAP.html Chapter 20 – Shared Address Book (LDAP) Version: – openldap-servers 2.3.19 – phpLDAPadmin 1.0.1 Initial Concepts Basic Configuration Address Book Entries TLS Link Encryption phpLDAPadmin Web Administrator Email Client Settings Many individuals throughout professional organisations will consider their list of personal and professional contacts as one of their most important assets. Similarly at […]
The big discussion surrounding iOS 7 has been regarding a new driven by Jony Ive, who took over control of Apple’s software-focused Human Interface team late last year in addition to his longtime role as head of Industrial Design. rumors says iOS7 , iRadio , MAC OS X 10.9 and macbookpro updates
This chapter discusses some configuration settings that seem to be fairly common. More examples and discussion can be found in the Exim book. 1. Sending mail to a smart host If you want to send all mail for non-local domains to a “smart host”, you should replace the default dnslookup router with a router which does the […]
mysql> create database ajay; Query OK, 1 row affected (0.00 sec) CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’localhost’; FLUSH PRIVILEGES;
This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the […]
How to install MySQL Install MySQL yum install mysql-server mysql php-mysql How to configure MySQL Set the MySQL service to start on boot chkconfig –levels 235 mysqld on Start the MySQL service service mysqld start Log into MySQL mysql -u root Set the root user password for all local domains SET PASSWORD FOR ‘root’@’localhost’ […]
You can pipe the output of mailq through various other filters but simply you can do this # mailq | tail -1 or this mailq | grep -c “^[A-Z0-9]”
FTP hangs or throws these error after a successful login. Vsftp – ftp: connect: No route to host This is because the FTP-data port is blocked by a firewall. 1. Make sure that passive mode is enabled (vsftp enables it by default). Check the file /etc/vsftpd/vsftpd.conf, for the following lines pasv_enable=YES 2. Also check whether […]
