Home PHP
What is disabled by default is remote root access. If you want to enable that, run this SQL command locally:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
And then find the following line and comment it out in your my.cnf file, which usually lives on /etc/mysql/my.cnf on Unix/OSX systems. In some cases the location for the file is /etc/mysql/mysql.conf.d/mysqld.cnf).
If it's a Windows system, you can find it in the MySQL installation directory, usually something like C:\Program Files\MySQL\MySQL Server 5.5\ and the filename will be my.ini.
Change line
bind-address = 127.0.0.1
to
#bind-address = 127.0.0.1
And restart the MySQL server (Unix/OSX, and Windows) for the changes to take effect.
if this not working. check the 3306 port.
sudo ufw status
run this command to enable port
sudo ufw allow 3306
restart mysql
How to install php_imagick.dll in windows php. you need to know the exact version of your PHP. To do this: open a command prompt and enter these commands
Determine the PHP version:
php -i|find "PHP Version"
Determine the thread safety
php -i|find "Thread Safety"
You’ll have enabled for thread safe or disable for not thread safe
Determine the architecture
php -i|find "Architecture"
You’ll have x86 for 32 bits and x64 for 64 bits
Sometime after you install binary, example composer and package from composer. You must add composer to PATH, so many tutorial export PATH but is temporarly. Then how to add the path permanent.
sudo nano /etc/paths
echo $PATH
How to detect php.ini on mac,
easy to detect php.ini folder. you can use 2 way.
1. create file info.php and put this script
<?php
phpinfo();
?>
php -i | grep php.ini
Composer untuk windows bisa langsung di download di getcomposer.org. tapi bagaimana dengan mac atau linux. kalian bisa menggunakan cara ini untuk install composer di mac os atau linux.
setelah itu kalian bisa menggunakannya composer di folder project tersebut dengan cara$ cd /path/to/my/project
$ curl -s http://getcomposer.org/installer | php
curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composer