{"id":15798,"date":"2024-12-28T11:39:09","date_gmt":"2024-12-28T09:39:09","guid":{"rendered":"https:\/\/www.beseit.net\/?p=15798"},"modified":"2026-02-23T14:32:12","modified_gmt":"2026-02-23T12:32:12","slug":"connexio-a-mariadb-des-de-putty","status":"publish","type":"post","link":"https:\/\/www.beseit.net\/?p=15798","title":{"rendered":"Connexi\u00f3 a MariaDB des de Putty"},"content":{"rendered":"\n
mysql -u root -p -P 3307 --socket=\/run\/mysqld\/mysqld10.sock\n<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Quins permisos t\u00e9 miquel:<\/p>\n\n\n\n
SHOW GRANTS FOR 'miquel'@'%';\n(des consola MariaDB)\n\nMariaDB [(none)]> SHOW GRANTS FOR 'miquel'@'%';\n+-------------------------------------------------------------------------------------------------------+\n| Grants for miquel@%                                                                                   |\n+-------------------------------------------------------------------------------------------------------+\n| GRANT USAGE ON *.* TO `miquel`@`%` IDENTIFIED BY PASSWORD '*C0C6BA4DF19B94D2C2BA6C12DD5EFF4E201B9478' |\n| GRANT ALL PRIVILEGES ON `polidic_eng`.* TO `miquel`@`%`                                               |\n+-------------------------------------------------------------------------------------------------------+\n2 rows in set (0.000 sec)\n\nMariaDBDB  [(none)]> (el none vol dir que no est\u00e0 connectat a cab base de dades)\n\n\n\n\n<\/code><\/pre>\n\n\n\n
Selecciona la base de dades <\/strong>polidic_eng<\/code>:<\/p>\n\n\n\n
USE polidic_eng;\n\nVerifica els permisos de l'usuari miquel:\nSHOW GRANTS FOR 'miquel'@'%';\n\nsi cal: \nGRANT ALL PRIVILEGES ON polidic_eng.* TO 'miquel'@'%' IDENTIFIED BY 'B********!';\nFLUSH PRIVILEGES;\n\n<\/code><\/pre>\n\n\n\n
urqtejmi@synology_vall:~$ mysql -u root -p -P 3307 –socket=\/run\/mysqld\/mysqld10.sock
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \\g.
Your MariaDB connection id is 1498
Server version: 10.11.6-MariaDB Source distribution<\/p>\n\n\n\n
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<\/p>\n\n\n\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n\n\n\n
MariaDB [(none)]><\/p>\n\n\n\n
Reiniar maria db<\/h2>\n\n\n\n
mysqMariaDB es troba aqui:<\/p>\n\n\n\n
urqtejmi@synology_vall:\ncd \/volume2\/@appstore<\/mark>\n\nActiveBackup\t\t\t\nActiveBackup-Office365\t\t\nAntiVirus\t\t\t\t\t\t\t\t\t\t\t\nApache2.2\nApache2.4\t\t\nAudioStation\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nCalendar\t\t\t\t\t\t\t\t\t\t\t\nCloudSync\t\t\t\t\t\t\t\nCodecPack\t\t\t\t\t\t\t\t\t\t\t\nContacts\t\t\t\t\t\t\t\t\t\t\t\nContainerManager\t\t\nDNSServer\t\t\t\t\t\nDownloadStation\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nGit\t\nHyperBackup\t\t\t\t\t\t\t\t\t\nHyperBackupVault\t\t\nLogCenter\t\t\t\nMailClient\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nMailPlus-Server\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nMariaDB10<\/mark>\t\t\t\n\nNode.js_v14\t\nNode.js_v16\t\nNode.js_v18\t\nNode.js_v20\nNoteStation\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nPDFViewer\t\t\t\t\nPerl\nPHP5.6\nPHP7.0\nPHP7.4\t\nPHP8.0\t\t\nPHP8.1\t\t\nPHP8.2\t\t\nphpMyAdmin\t\t\t\t\t\t\t\t\t\t\t\t\nPython3.9\t\t\nSnapshotReplication\t\t\nStorageAnalyzer\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nSynologyDrive\t\t\t\t\t\t\t\t\t\t\t\t\nSynologyPhotos\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nTextEditor\t\nUniversalViewer\t\nVideoStation\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nVPNCenter\t\t\nWebDAVServer\nWebStatio\t\t<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\nurqtejmi@synology_vall:\/volume2\/@appstore\/MariaDB10$\n<\/code><\/pre>\n\n\n\n
sudo \/usr\/local\/mariadb10\/bin\/mysqld restart ?\n<\/code><\/pre>\n\n\n\n
sudo systemctl restart mariadb ?\n<\/code><\/pre>\n\n\n\n
urqtejmi@synology_vall:\/volume2\/@appstore\/MariaDB10\/port_conf$ sudo cat \/volume2\/@appstore\/MariaDB10\/port_conf\/MariaDB10.sc
Password:
[MariaDB10]
title=MySQL
dst.ports=”3307\/tcp”
port_forward=no<\/mark>
desc=MariaDB 10<\/p>\n\n\n\n
Editar el fitxerCD<\/h2>\n\n\n\n
Obrir sariaDB10.sc am l'edir de linia vi:<\/code><\/pre>\n\n\n\n
sudo vi \/volume2\/@appstore\/MariaDB10\/port_conf\/MariaDB10.sc\n\nRedordar (premer i per entrar al editor de linia)\ni <\/mark>per editar\nscape per sorti\n:wq<\/mark> enter per salvar\n\nsudo vi \/volume2\/@appstore\/MariaDB10\/port_conf\/MariaDB10.sc\n\n<\/code><\/pre>\n\n\n\n
Per verificar contingut:<\/p>\n\n\n\n
sudo vi \/volume2\/@appstore\/MariaDB10\/port_conf\/MariaDB10.sc i sortie :wp<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Quins permisos t\u00e9 miquel: Selecciona la base de dades polidic_eng: urqtejmi@synology_vall:~$ mysql -u root -p -P 3307 –socket=\/run\/mysqld\/mysqld10.sockEnter password:Welcome to the MariaDB monitor. Commands end with ; or \\g.Your MariaDB connection id is 1498Server version: 10.11.6-MariaDB Source distribution Copyright (c) … Continua llegint →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":8179,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-15798","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bloc-de-notes"],"_links":{"self":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/15798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15798"}],"version-history":[{"count":11,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/15798\/revisions"}],"predecessor-version":[{"id":17719,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/15798\/revisions\/17719"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/media\/8179"}],"wp:attachment":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}