how to change phpmyadmin url in apache ubuntu

Featured

October 8, 2022 in MySql, Ubuntu

how to change phpmyadmin url in apache ubuntu

For ubuntu (i used ubuntu 12.04), the default phpmyadmin apache configuration can be found at /etc/phpmyadmin/apache.conf

You can open it by type sudo nano /etc/phpmyadmin/apache.conf and change the third

Alias /yournewalias /usr/share/phpmyadmin

To restart apache service

sudo service apache2 restart

August 19, 2022 in MySql

how many employees in department MySQL query

Get the department name and number of employees in the department

SELECT department_name AS 'Department Name', 
COUNT(*) AS 'No of Employees' 
FROM departments 
INNER JOIN employees 
ON employees.department_id = departments.department_id 
GROUP BY departments.department_id, department_name 
ORDER BY department_name;
Department Name		No of Employees
Accounting			2
Administration			1
Executive			3
Finance				6
Human Resources			1
IT				5
Marketing			2
Public Relations		1
Purchasing			6
Sales				34
Shipping			45

August 17, 2022 in MySql, Tips and Tricks

Maximum execution time of 300 seconds exceeded in

Xampp Users

  1. Go to xampp\phpMyAdmin\
  2. Open config.inc.php
  3. Search for $cfg['ExecTimeLimit'] = 300;
  4. Set a larger value or change to 0 for unlimited
  5. If not found add $cfg['ExecTimeLimit'] = 900; (or 0 for unlimited)
  6. Save the file and restart the server

Important: setting the execution time limit to unlimited is not recommended.

July 24, 2022 in MySql, Ubuntu

after copy paste ibd is not working centos 7

remove mysql install in centos 7

yum remove mysql
yum remove mysql-server
yum clean all

Install MySQL server centos 7

yum install mysql mysql-server

OR

yum install mysql
yum install install mysql-server

July 20, 2022 in MySql

Install MySQL server centos 7

yum install mysql mysql-server

OR

yum install mysql
yum install install mysql-server

May 12, 2022 in MySql

how to change localhost URL in WordPress

Use the following sql commands in phpmyadmin

UPDATE wp_options SET option_value = 'http://new-domain-name.com' WHERE  option_name = 'home';

UPDATE wp_options SET option_value = 'http://new-domain-name.com' WHERE option_name = 'siteurl';

UPDATE wp_posts SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');

UPDATE wp_posts SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');

April 26, 2022 in MySql, Ubuntu

sql_mode value change permanently

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

Then restarted mysql

sudo service restart mysql