Web site administration may be a complex management issue sometimes expecially if you want a totally dynamic custom content management system for your web site. I'm a backend web developer and use my own admin panel software to provide cms for my clients worldwide. Some of my clients use a ready made high quality template/theme for their web projects while some prefer having a custom web design and user interface according to their requirements.
Actually i'm not involved in the design and ui parts of web projects but i do the back end works like database development, providing an administration panel for content management and also converting web site front end to a dynamic complete web site project. In the video below you can find a demo of my admin panel software being used on a sample project.
If you would like to have your web template turned into a dynamic web site using this website admin panel, you can contact me using the contact form below to get an offer for your project.
Website Language
Tuesday, January 7, 2020
Saturday, January 4, 2020
Mysql connection problems and setting root password
Recently i had to make a fresh install to my Linux machine. While installing software and packages i need regularly i had some problems with mysql server. I had errors while trying to connect as root user. Here i will note the steps for solving the problem and resetting mysql root password step by step.
(Please enter/copy the commands one by one. Do not copy all commands at once and paste to terminal. Terminal shortcut is Ctrl Alt T)
If you had edited mysql configuration and would like to start from the beginning without confusion, you may prefer to purge your mysql server installation and install again using these commands:
First i opened a terminal window and entered the following commands. I used the first two commands because i had an error about permission problem for /var/run/mysqld directory while starting mysql server.
You should be able to access mysql query terminal now. Enter the following mysql commands:
When you turn to terminal enter these commands for testing your connection.
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start # reset mysql
mysql -u root -p
(Please enter/copy the commands one by one. Do not copy all commands at once and paste to terminal. Terminal shortcut is Ctrl Alt T)
If you had edited mysql configuration and would like to start from the beginning without confusion, you may prefer to purge your mysql server installation and install again using these commands:
sudo apt purge mysql-server
sudo apt-get install mysql-server
First i opened a terminal window and entered the following commands. I used the first two commands because i had an error about permission problem for /var/run/mysqld directory while starting mysql server.
sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql -R /var/run/mysqld
sudo /etc/init.d/mysql stop
sudo mysqld_safe --skip-grant-tables &
(press enter)
mysql -uroot
You should be able to access mysql query terminal now. Enter the following mysql commands:
use mysql;
update user set authentication_string=PASSWORD("yourrootpassword") where User='root';
update user set plugin="mysql_native_password" where User='root';
flush privileges;
quit;
When you turn to terminal enter these commands for testing your connection.
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start # reset mysql
mysql -u root -p
When your connection is ok you can also test using your mysql admin software like phpmyadmin, adminer etc. to be sure that you can connect on web too. If you get errors about missing plugins etc. make sure that you have installed mysql module for php and restart apache server.
Subscribe to:
Posts (Atom)