I went to Cpanel, and from there created a user and a database with the option MySQL Databases in Cpanel. I inserted and created tables without any problem. Now when I want to connect to it, with these parameters: $servername…
I am having an issue setting the php my admin database up as a master slave. I am developing locally and want to set up the server database as a slave. There is an option to replicate the database in…
Error in processing request: No routine with name 'daily_difference' found in database 'chamelis_wp'. You might be lacking the necessary privileges to edit this routine.
I am moving a Magento 1.8 web to a lower cost hosting and exhausted by phpmyadmin installation. Magento 1.8 was suggested to run with PHP 5.4 and Mysql 5.5, therefore, I chose a Centos6.9 image and thought could be easier...The…
How to change cPanel date.time zone? My php.ini is like this: magic_quotes_gpc = Off; register_globals = Off; default_charset = UTF-8; memory_limit = 64M; max_execution_time = 36000; upload_max_filesize = 999M; safe_mode = Off; mysql.connect_timeout = 20; session.auto_start = Off; session.use_only_cookies =…
I want to create a dev environment of my website on the same server. But I have a 7Gb of database which contains 479 tables and I want to make a copy of that database to the new DB. I…
I am not proficient in MySQL and phpMyAdmin and got this error when trying to import my SQL file to a new installation of WAMP. I was developing a joomla website on my local pc and after completion, decided to…
So I have two tables in my phpmyadmin like tabel1 and tabel2 in both tables, i want to select id = 2 so I have tried mysql_query('SELECT * FROM tabel1, table2 WHERE id=2'); but not working plz give me some…
Can any please help me in below issue. I am planning to host more than one site on single AWS ec-2 Instance, now I want every site have its own cpanel and phpmyadmin. Confusion should I need to install Cpanel…
When I try to sign into my websites wp-admin login screen it refreshes and redirects me to the login page. After researching this issue it looks like deactivating the plugins should fix the issue. However, when I try doing this…