Category : MYSQL

install phpMyAdmin easily on Elastix if it isn’t installed: yum install -y phpmyadmin Then edit the file /etc/httpd/conf.d/phpMyAdmin.conf Add the line “Allow from all” to this entry so it ends up looking like this: Order Deny,Allow Deny from All Allow from 127.0.0.1 Allow from All Allow from ::1 Then type /etc/init.d/httpd restart Then you can ..

Read more

@echo off CLS cd c:\temp set MYSQLUSER=root set MYSQLPASS=PassWord set BATCHFILE=c:\temp\Batch_mysqldump.bat set DUMPPATH=c:\temp SET backuptime=%DATE:~4,2%-%DATE:~7,2%-%DATE:~10,4%-%TIME:~0,2%-%TIME:~3,2% SET backuptimelog=%DATE:~4,2%-%DATE:~7,2%-%DATE:~10,4% %TIME:~0,2%:%TIME:~3,2%:%TIME:~6,2% echo starting MySqlDump at %backuptime% echo —— starting MySqlDump at %backuptimelog% —— >> “Z:\-=macine backup=-\sqldump\sqldump.log” echo Running dump… set 7zip_path= mkdir “%backuptime%” >> “Z:\-=macine backup=-\sqldump\sqldump.log” cd “c:\Program Files\MySQL\MySQL Server 5.6\bin” echo @echo off > %BATCHFILE% echo cd ..

Read more

Web services ( application services ) is one of the most important part of today development where we ceneteralized or data and allow user to access that data from different sources like web, software, app etc.. Web service provide Interoperability between two different language.  Web service are easy to understand or to made we can easily create ..

Read more

How to reset the Mysql root password in case of password forget.   Follow the below steps to reset the mysql password.   ***************************** Step 1 : stop the mysql ***************************** /etc/init.d/mysql stop   it will outputs  stopping MySQL database server : mysqld   ***************************** Step 2 : starting the mysql in safemode ***************************** run ..

Read more

Read more: http://mrbool.com/how-to-insert-a-record-in-mysql-with-php/28621#ixzz47s0C2cqJ Requirements for techniques: We will require in this article to create a simple contact page for a website, i.e. HTML 5 CSS 3 PHP MySQL database Xampp Server Requirements for Environment: It’s up to on you on which application you can work easily, as there are number of applications which are being ..

Read more

Read more: http://mrbool.com/how-to-create-a-sign-up-form-registration-with-php-and-mysql/28675#ixzz47rznG0YC   Much of the websites have a registration form for your users to sign up and thus may benefit from some kind of privilege within the site. In this article we will see how to create a registration form in PHP and MySQL. We will use simple tags and also we will ..

Read more

Introduction It’s easy to use PHP with MySQL to create it. But for these kind of webpages we need to use form validation on our webpages, if anyone use JavaScript so it’s well and good because JavaScript is a very good technique to use and solve Form Validation problems. But we will directly go to ..

Read more

Modify the my.ini configuration file (assuming default paths) C:\Program Files\MySQL\MySQL Server 5.5\my.ini In the SERVER SECTION, under [mysqld], add the following line: skip-grant-tables so that you have # SERVER SECTION # ———————————————————————- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see ..

Read more