Open & Edit /etc/my.cnf or /etc/mysql/my.cnf, depending on your distro. Add skip-grant-tables under [mysqld] Restart Mysql You should be able to login to mysql now using the below command mysql -u root -p Run mysql> flush privileges; Set new password by ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘NewPassword’; Go back to /etc/my.cnf and remove/comment skip-grant-tables Restart Mysql Now you will be able to login with the new … Read more
4 I take an index on the barcode column as a given. You could save space if you stored the codes as numbers. Space is time as less bytes can be read faster. Also, the lookup should be faster on numbers. The leading zeros can be reconstructed when needed as UPC-A is a fixed-length code.
The second (assuming you means CONTAINS, and actually put it in a valid query) should be faster, because it can use some form of index (in this case, a full text index). Of course, this form of query is only available if the column is in a full text index. If it isn’t, then only the first form is available. … Read more