Levent Ozturk
Enter
Ubuntu MYSQL mysql: apt-get install libmysqlcppconn-dev # for c++ libraries to connect to mysql gcc /root/apache-websocket/examples/mysqlc.c $(mysql_config --cflags) $(mysql_config --libs) gcc is6.c -o is6 $(mysql_config --libs) mysql fails to start: check /etc/mysql/my.cnf for => tmpdir = /tmp check /var/log/mysql/error.log see if Can't create/write to file '/tmp/ exists then chown root:root /tmp chmod 1777 /tmp and restart the server service mysql start or create a seperate tmp for user mysql only owned by mysql user. and point tmpdir variable to it in /etc/mysql/my.cnf mysql client cli: mysql -u root -p if fails to login (access denied) sudo /etc/init.d/mysql stop sudo mysqld_safe --skip-grant-tables & mysql >use mysql; >select * from user; #Make sure root and mysql users are created. >update user set password=PASSWORD("mynewpassword") where User='root'; >update user set password=PASSWORD("mynewpassword") where User='mysql'; >flush privileges; if somehow root and mysql is not created create a new user with previlidges. >CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; >GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost'; >FLUSH PRIVILEGES; Above method for creation will not work in --skip-grant-tables mode. So >Insert into user set User=<>, all prevelidges='Y'; exit;reboot;mysql -u levent -proot MYSQL Misc: SELECT User FROM mysql.user; show databases; GRANT INSERT ON leventozturk.com_fbt.* to 'leventozturk.com_fbt'@'localhost';
All the material listed and linked at this World Wide Web domain are strictly private property and copyrighted. © Copyright -∞-∞ Levent Ozturk. All rights reserved. Reproduction or use of any material, documents and related graphics and any other material from this World Wide Web server is strictly prohibited. Site Map