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… Read More »
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. Again. So I had to search the net, again, and find out what I was doing wrong,… Read More »
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… Read More »
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. It seems some of the reasons are: – ensure referential integrity assist with visualizing and… Read More »
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… Read More »
I happened to have a quick look at the jobs available at the Bureau of Meteorology yesterday. They have a “Systems and Database Specialist” position available starting at $80K. Although I’m not going to apply for it, it has given me some ideas on how/where to improve my skills. Database Tuning mySQL Linux AIX (not… Read More »
I’ve had a few problems creating users, assigning passwords and granting access to uses in MySQL. Below is one method I’ve found that works, at least for WordPress databases. mysql> create database wordpressdb; mysql> create user ‘wordpressuser’@’localhost’; mysql> set password for ‘wordpressuser’@’localhost’=PASSWORD(‘password’); mysql> use wordpressdb; mysql> grant all on * to ‘wordpressuser’@’localhost’;
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.
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… Read More »
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.