Download aqui

[rickybraz]

instalei o mariadb mas ao fazer o comando mysql_secure_installation, ele pede a senha e acontece o seguinte erro:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory")

o que pode ser? estou usando como base o tutoria: https://wiki.archlinux.org/index.html/MySQL

[pagani]

Olá. Você digitou esse comando antes do mysql_secure_installation?

Código: Selecionar todos

# mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

É preciso também "startar" o serviço e colocá-lo para rodar na inicialização:

Código: Selecionar todos

sudo systemctl start mysqld
sudo systemctl enable mysqld

e para ver se está rodando o mysql execute:

Código: Selecionar todos

sudo systemctl status mysqld

[rickybraz]

Quando dou o comando:mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql dá o erro:

Código: Selecionar todos

[[email protected] ricardo]# mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
150418 10:08:03 [ERROR] mysqld: File './mysql-bin.index' not found (Errcode: 13 "Permission denied")
150418 10:08:03 [ERROR] Aborting

150418 10:08:03 [Note] /usr/sbin/mysqld: Shutdown complete


Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

shell> /usr/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

shell> /usr/sbin/mysqld --skip-grant --general-log &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables;

Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /var/lib/mysql that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-sy ... install_db
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria

Please check all of the above before submitting a bug report
at http://mariadb.org/jira

[pagani]

Após instalar você iniciou o serviço mysqld?

[rickybraz]

Instalei via gerenciador de programas e fiz o comando conforme mandas mas não funcionou aí desinstalei pelo mesmo gerenciador e, de novo, ao tentar startar da erro:

Código: Selecionar todos

[[email protected] ricardo]# sudo systemctl start mysqld
Job for mysqld.service failed. See "systemctl status mysqld.service" and "journalctl -xe" for details.
[[email protected] ricardo]# systemctl status mysqld.service
● mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: activating (start-post) (Result: exit-code) since Sáb 2015-04-18 11:30:13 BRT; 53s ago
  Process: 3856 ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
 Main PID: 3856 (code=exited, status=1/FAILURE);         : 3857 (mysqld-post)
   CGroup: /system.slice/mysqld.service
           └─control
             ├─3857 /bin/sh /usr/bin/mysqld-post
             └─4230 sleep 1


Abr 18 11:30:13 ricky mysqld[3856]: 150418 11:30:13 [ERROR] mysqld: File './mysql-bin.index' not found (Errcode: 13 "Permiss...enied")
Abr 18 11:30:13 ricky mysqld[3856]: 150418 11:30:13 [ERROR] Aborting
Abr 18 11:30:13 ricky mysqld[3856]: 150418 11:30:13 [Note] /usr/bin/mysqld: Shutdown complete
Abr 18 11:30:14 ricky systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Hint: Some lines were ellipsized, use -l to show in full.
[[email protected] ricardo]# journalctl -xe
Abr 18 11:27:16 ricky su[2593]: pam_unix(su:session): session opened for user root by ricardo(uid=1000)
Abr 18 11:27:30 ricky sudo[2703]: root : TTY=pts/0 ; PWD=/home/ricardo ; USER=root ; COMMAND=/usr/bin/systemctl start mysqld
Abr 18 11:27:30 ricky sudo[2703]: pam_unix(sudo:session): session opened for user root by ricardo(uid=0)
Abr 18 11:28:43 ricky systemd[1]: mysqld.service start-post operation timed out. Stopping.
Abr 18 11:28:43 ricky systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit mysqld.service has failed.
--
-- The result is failed.
Abr 18 11:28:43 ricky systemd[1]: Unit mysqld.service entered failed state.
Abr 18 11:28:43 ricky systemd[1]: mysqld.service failed.
Abr 18 11:28:43 ricky sudo[2703]: pam_unix(sudo:session): session closed for user root
Abr 18 11:28:43 ricky mysqld[3220]: 150418 11:28:43 [ERROR] mysqld: File './mysql-bin.index' not found (Errcode: 13 "Permission denied
Abr 18 11:28:43 ricky mysqld[3220]: 150418 11:28:43 [ERROR] Aborting
Abr 18 11:28:43 ricky mysqld[3220]: 150418 11:28:43 [Note] /usr/bin/mysqld: Shutdown complete
Abr 18 11:28:43 ricky systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Abr 18 11:30:13 ricky systemd[1]: mysqld.service start-post operation timed out. Stopping.
Abr 18 11:30:13 ricky systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit mysqld.service has failed.
--
-- The result is failed.
Abr 18 11:30:13 ricky systemd[1]: Unit mysqld.service entered failed state.
Abr 18 11:30:13 ricky systemd[1]: mysqld.service failed.
Abr 18 11:30:13 ricky mysqld[3856]: 150418 11:30:13 [ERROR] mysqld: File './mysql-bin.index' not found (Errcode: 13 "Permission denied
Abr 18 11:30:13 ricky mysqld[3856]: 150418 11:30:13 [ERROR] Aborting
Abr 18 11:30:13 ricky mysqld[3856]: 150418 11:30:13 [Note] /usr/bin/mysqld: Shutdown complete
Abr 18 11:30:14 ricky systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
lines 1800-1833/1833 (END)

[pagani]

Não sei bem como você está instalando, mas acabei de fazer a instalação e está tudo OK.

Realizei os seguintes passos:

Código: Selecionar todos

sudo pacman -S mariadb

Código: Selecionar todos

 sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

Código: Selecionar todos

sudo systemctl start mysqld

Código: Selecionar todos

sudo mysql_secure_installation

e, por último:

Código: Selecionar todos

sudo systemctl status mysqld

Veja saída que obtive no terminal:

[[email protected] ~]$ sudo systemctl status mysqld
[sudo] senha para sergio:
● mysqld.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
Active: active (running) since Sáb 2015-04-18 12:49:01 AMT; 5min ago
Process: 5322 ExecStartPost=/usr/bin/mysqld-post (code=exited, status=0/SUCCESS)
Main PID: 5321 (mysqld)
CGroup: /system.slice/mysqld.service
└─5321 /usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid

Abr 18 12:49:00 manjaro mysqld[5321]: 150418 12:49:00 [Note] InnoDB: Highes...a.
Abr 18 12:49:00 manjaro mysqld[5321]: 150418 12:49:00 [Note] InnoDB: 128 ro...e.
Abr 18 12:49:00 manjaro mysqld[5321]: 150418 12:49:00 [Note] InnoDB: Waitin...rt
Abr 18 12:49:00 manjaro mysqld[5321]: 150418 12:49:00 [Note] InnoDB: Perco...17
Abr 18 12:49:00 manjaro mysqld[5321]: 150418 12:49:00 [Note] Plugin 'FEEDBA...d.
Abr 18 12:49:00 manjaro mysqld[5321]: 150418 12:49:00 [Note] Server socket ...'.
Abr 18 12:49:00 manjaro mysqld[5321]: 150418 12:49:00 [Note] Event Schedule...ts
Abr 18 12:49:01 manjaro mysqld[5321]: 150418 12:49:01 [Note] /usr/bin/mysql...s.
Abr 18 12:49:01 manjaro mysqld[5321]: Version: '10.0.17-MariaDB-log' socke...er
Abr 18 12:49:01 manjaro systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.

Se você tem alguma instalação, sugiro que remova e refaça apenas estes passos indicados acima pra ver se resolve.

[AlehAmazon]

No meu caso funcionou só até sudo systemctl start mysqld. quando dou o proximo comando ele pede senha root e já avisa que a senha padrão é em branco que bastar clicar ENTER...

In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

mas recebo essa resposta.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Enter current password for root (enter for none):

ela não esta considerando uma senha em branco.