Very often you would like to change the default data location of MySQL for obvious reasons. If you do that and you don’t change the phpmyadmin settings accordingly, you will not be able to login via phpmyadmin. You will constantly be getting the “Access denied” message.
Let’s say that you have added a new file system mounted under /data and you would like all MySQL data to be stored there.
Normally I set this up before I ever create new databases on the server. But in case you are moving existing databases from one data dir to another you need to copy them over to the new location first, otherwise go directly to editing the my.cnf file below.
Stop mysql:
$ sudo systemctl stop mysqldNow that the server is shut down, we’ll copy the existing database directory to the new location with rsync. Using the -a flag preserves the permissions and other directory properties, while -v provides verbose output so you can follow the progress.
Note: Be sure there is no trailing slash on the directory, which may be added if you use tab completion. When there’s a trailing slash, rsync will dump the contents of the directory into the mount point instead of transferring it into a containing mysql directory:
$ sudo rsync -av /var/lib/mysql /dataNow you are ready to change the MySQL configuration. To do that you need to update the /etc/my.cnf (CentOS/RHEL) /etc/mysql/my.cnf (Ubuntu) file:
$ sudo vi /etc/my.cnfFind the datadir and socket entries under [mysql] and update them to point to the new data directory:
[mysql]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
After updating the existing lines, we’ll need to add configuration for the mysql client. Add the following three lines at the end of that file, right above the !includedir /etc/mysql/conf.d/ line and the comment above it:
[client]
port=3306
socket=/data/mysql/mysql.sockWe are all set with the MySQL configuration and we can start db the server:
$ sudo systemctl start mysqldIf you have phpMyAdmin installed you need to reconfigure it to use socket authentication and point to the new location of the mysql socket. If you don’t do this, you will not be able to login via phpMyAdmin.
Edit the /etc/phpMyAdmin/config.inc.php (CentOS/RHEL) /etc/phpmyadmin/config.inc.php (Ubuntu) file:
$ sudo vi /etc/phpMyAdmin/config.inc.phpChange the socket and data_type. Normally the data_type would be set to ‘tcp’. Change it to ‘socket’ instead. Then set the new location of the socket:
$cfg['Servers'][$i]['socket'] = '/data/mysql/mysql.sock'; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'socket'; // How to connect to MySQL server ('tcp' or 'socket')You are all set. Restart Apache and you should be good to go.
???????? ????? ??????????? ? ?? ??????
??? ?????????? ??????????? ? ?? ??????
joszaki regisztracio joszaki
joszaki regisztracio joszaki.hu
lucky neko pg soft dizayn? çox c?lbedicidir. ?n maraql? demo üçün keçid: pg soft lucky neko. demo lucky neko test üçün göz?l imkand?r.
lucky cat lucky cat maneki neko kolleksiyas? maraql?d?r. neko lucky cat slotda u?uru simvolla?d?r?r. Demo üçün birba?a link: https://lucky-neko.com.az. jogar lucky neko demo oyunçular üçün rahatd?r. lucky neko slot demo çox m??hur seçimdir. demo lucky neko real oyun üçün haz?rlay?r. lucky cat maneki-neko u?ur g?tir?n simvoldur. lucky neko demo slot vaxt keçirm?k üçün ?lad?r.
????????? ?????? ????????, ?????????? ???? ????????? ? ????????. ??????? ??????? ?????? ???, ??? ? ????? ??? ????. ???? ????? ???????. ????? ???????, ??????????? ?????? ???????? ??????? – https://sibirki3.vip/. ????? ??????? ????????, ??? ?? ?????? ??????.
???????? ??????????? ???????? ???????
??????? ???????? ??????????? ? ????????
Excellent pieces. Keep writing such kind of information on your site. Im really impressed by your site.
Hi there, You’ve performed a great job. I’ll definitely digg it and individually recommend to my friends. I am confident they will be benefited from this web site.
Vegastars
Unlock your images with WebPtoJPGHero.com, the simple, free solution for solving WebP compatibility issues. While the WebP format helps websites load faster, it can leave you with files you can’t easily edit or share. Our online tool provides an instant fix, transforming any WebP image into a high-quality JPG that works seamlessly across all your devices and applications. You can fine-tune the output quality to balance clarity and file size, and even save time by converting an entire batch of photos at once. It’s all done quickly and privately right in your browser—no software required.
WebPtoJPGHero.com
JPG Hero converter is an online image converter built for speed, simplicity, and accessibility. This web-based platform allows instant conversion of popular image formats such as PNG, WebP, and BMP into JPG files. No downloads, installations, or user accounts are required. The entire process happens in-browser and takes only a few seconds. Users can upload up to 20 files at once for batch conversion, making it suitable for individuals and professionals managing multiple images. All uploaded files are automatically deleted after processing to maintain privacy and ensure data security. JPGHero.com is compatible with all modern devices, including desktops, tablets, and smartphones, offering flexibility for work on the go. Whether the goal is to reduce image file size, prepare visuals for the web, or standardize a project’s image format, this tool delivers clean, reliable results without any extra steps.
JPGHero
Formula 1 puan durumu daim yenil?nir v? oyunçular üçün ?lçatand?r. Formula 1 logo v? brendl??m? detallar?n? k??f edin.
Könüllü proqram? il? ba?l? ?trafl? m?lumat ? formula 1 volunteer 2025.
Formula 1 haqqinda melumat axtaranlar üçün faydal? m?nb?. Formula 1 Bak? 2024 biletl?ri onlayn ?ld? oluna bil?r.
Formula 1 schedule izl?yicil?r üçün rahat seçimdir. Formula 1 haqq?nda ?n çox veril?n suallar. Formula 1 movie izl?yicil?r üçün ?yl?nc?li seçimdir. Formula 1 izl?m? t?crüb?sini rahatla?d?ran xidm?tl?r.
WebPtoJPGHero converter is an online image converter built for speed, simplicity, and accessibility. This web-based platform allows instant conversion of popular image formats such as PNG, WebP, and BMP into JPG files. No downloads, installations, or user accounts are required. The entire process happens in-browser and takes only a few seconds. Users can upload up to 20 files at once for batch conversion, making it suitable for individuals and professionals managing multiple images. All uploaded files are automatically deleted after processing to maintain privacy and ensure data security. WebPtoJPGHero is compatible with all modern devices, including desktops, tablets, and smartphones, offering flexibility for work on the go. Whether the goal is to reduce image file size, prepare visuals for the web, or standardize a project’s image format, this tool delivers clean, reliable results without any extra steps.
WebPtoJPGHero
???????? «???-??????» — ???????????????? ?????? ?????????? ????? ? ??? !
??? ?????? ?? ?????? ? ???????????? ???????? ?????? ??: vk.com/remont_stiralnyh_mashin_spb_top
???????????? ?????? ?????????? ????? ? ??? ????????? ??????? ??????? ? ??????????? ??????. ?????? ?????????? ????? ??? ???????? ???????????, ?????? ????????? ? ????????? ??????? ????? ?????. ???? ????????? ??????? ?????? ?????????? ????? — ??????????? ????????? ? ???? ?????????.
– ???????? ?? 2 ???
– ???????????? ????????
– ????? ?? ????? ?????-??????????
?????? ?????????? ?????
Aw, this was a very good post. Taking the time and actual effort to make a really good article… but what can I say… I procrastinate a whole lot and don’t seem to get nearly anything done.
kra40cc ????
??????? ?? ???????? ????????????? ????????