mysql

After creating a basic jail do this: Step 1 Configue the the Jail to Use SSH https://www.ixsystems.com/documentation/freenas/11.2-U6/jails.html#accessing-a-jail-using-ssh Step 2 - Setup Apache, MySQL and PHP - NOTE: Make changes for your version of PHP https://www.digitalocean.com/community/tutorials/how-to-install-an-apache-mysql-and-php-famp-stack-on-freebsd-10-1 with minor changes from https://www.howtoforge.com/install-apache-php-mysql-on-freebsd-12/ Step 3 - install workpress https://www.digitalocean.com/community/tutorials/how-to-install

First, to check what is being used run this, SELECT user, authentication_string, plugin, host FROM mysql.user; If the user you are having issues with is set to auth_socket then you may need to change it to method with mysql_native_password Like this, mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; Change root to the user you need and set the password to whatever the password is supposed to be.

Every time I have to setup users in MySQL I seem to have problems. I was setting up a system to do some WordPress testing and installed MySQL OK, but ran into problems with the users and permissions.

If you are trying to get PHP, Apache and MySQL to work together one of the steps you have to do is edit the file /etc/php5/apache2/php.ini and uncomment the following line, extensions = mysql.so You then need to commented out the following lines, ;extension_dir = /usr/lib/php4/20020429-zts/ ;include_path = ".:/usr/share/php" NOTE : These are the only steps of course, its just one of the traps I came across while trying setup a server.

I've been looking at foreign key constraints today. I've managed to set a FK constraint in an Oracle and a MySQL database without too much trouble. But I was having trouble understanding why you would set up a FK constraint.

I did some digging and found out that Postgres is actually PostgreSQL an open source database. Much like MySQL.
I setup a spare laptop with Fedora 10 and installed it and got it running OK with only a few little hitches. Mostly from not knowing a thing about it.

Looks like it would be simple enough to use, it would just be a matter of learning the new syntax for everything.

At your shell prompt type # mysql -u <username> --password=<password> Where <username> and <password> are the username and password you entered when first setting up MySQL. You may also be able to login as root like this, # mysql -u root without using a password, depending on how your system was setup.

Backup the root filesystem (preferably in single user mode) # ufsdump 0f /mnt/backup.dmp / To restore the root filesystem Boot from the CD-ROM to single user mode OK> boot cdrom -s Resize the root partition using format Mount the HDD to be restored to: # mount -o rw -F ufs /dev/dsk/ /root_disk Restore from the root backup location # cd /root_disk # ufsrestore rf /backup/backup.dmp # cd / # umount /root_disk Check the disk # fsck -y /dev/dsk/ If necessary install a boot block on the partition # installboot /usr/platform/`uname -i`/lib/fs/ufs/bootblk /dev/rdks/ Reboot # init 6

To run a script from within mysql simply to the following mysql> source d:/my documents/run.sql; Where d:/my documents/run.sql is the path and name of the script you want to run.