Re: Modifier mot de passe user mysql : Access denied for user root

[JC.EtiembleG]

Le 11/02/2020 à 23:48, ajh.val...@free.fr a écrit :

J'ai tenté via moteur de recherche, rien ne marche,
dont "dpkg-reconfigure mysql-server".

Merci d'une aide, d'une piste...


A tester et adapter
Comment récupérer (perdu ou oublié) mon mot de passe root de MariaDB
"http://jc.etiemble.free.fr/abc/index.php/trucs-astuces/lamp/deb9php7#mdpperdu;

--
J-C Etiemble

Re: Modifier mot de passe user mysql : Access denied for user root

[G2PC]

> # mysql -u root -p
>
> J'ai toujours cette réponse :
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' 
> (using password: YES)
>
> J'ai tenté via moteur de recherche, rien ne marche,
> dont "dpkg-reconfigure mysql-server".
>
> Merci d'une aide, d'une piste...

Le mode sans échec de MySQL ?
https://www.debian-fr.xyz/viewtopic.php?t=210

Re: Modifier mot de passe user mysql : Access denied for user root

[ajh . valmer]

On Tuesday 11 February 2020 15:53:02 G2PC wrote:
> 
www.it-connect.fr/changer-de-mot-de-passe-mysql%EF%BB%BF/#III_Changer_le_mot_de_passe_utilisateur_avec_une_commande_SQL
> www.laurentsanselme.com/changer-le-mot-de-passe-dun-utilisateur-mysql/

# mysql -u root -p

J'ai toujours cette réponse :
ERROR 1045 (28000): Access denied for user 'root'@'localhost' 
(using password: YES)

J'ai tenté via moteur de recherche, rien ne marche,
dont "dpkg-reconfigure mysql-server".

Merci d'une aide, d'une piste...

Re: MySQL access denied for user

[Florian Pelgrim]

Hi,

I assume that you installed mysql from repository and did not alter the
configuration.

Login with root into mysql and then:

1. create your drupal database
# create database drupal;

2. create a user account for it
# create user 'drupal_user'@'localhost' IDENTIFIED BY
'some_random_stuff_here';

3. grant permissions to this database
# grant all privileges on drupal.* TO 'drupal_user'@'localhost';

4. flush privileges
# flus privileges;

I don't know why you listed every privilege in your grant but just stick
to this and it will work.

Downloading the current drupal version from upstream is ok since they
will usually have never versions than you can find in repository.

That shoudl work out of the box for you. ;)

Cheers

Am 15.08.16 um 07:17 schrieb Bill Wohler:
> Bill Wohler  wrote:
> 
>> I'm getting the following:
>>
>> $ mysql -h localhost -u user
>> Enter password: 
>> ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using 
>> password: YES)
>>
>> This user was created with a fresh installation of mysql as (mysql) root
>> with the following:
>>
>> mysql> create user 'user'@'localhost' identified by 'password';
>> Query OK, 0 rows affected (0.00 sec)
>> mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, 
>> CREATE TEMPORARY TABLES ON database.* TO 'user'@'localhost' IDENTIFIED BY 
>> 'password' with grant option;
>> Query OK, 0 rows affected (0.00 sec)
>>
>> I'm trying to create a database user for Drupal, but am not having any
>> luck. Help for a MySQL newb is very much appreciated.
> 
> I should point out that I've installed Drupal 8 from drupal.org since
> that isn't available to jessie (to my knowledge). I'd much prefer to say
> aptitude install drupal8 and get on with my web site rather than fight
> battles with mysql for literally days.
> 
>> This is on jessie with MySQL 5.5.
>>
>> -- 
>> Bill Wohler  aka 
>> http://www.newt.com/wohler/
>> GnuPG ID:610BD9AD
> 



signature.asc
Description: OpenPGP digital signature

Re: MySQL access denied for user

[limpia]

On 2016-08-15 04:54, Liam O'Toole wrote:

On 2016-08-15, Bill Wohler  wrote:

I'm getting the following:

$ mysql -h localhost -u user
Enter password:
ERROR 1045 (28000): Access denied for user 'user'@'localhost' 
(using password: YES)


This user was created with a fresh installation of mysql as (mysql) 
root

with the following:

mysql> create user 'user'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, 
ALTER, CREATE TEMPORARY TABLES ON database.* TO 'user'@'localhost' 
IDENTIFIED BY 'password' with grant option;

Query OK, 0 rows affected (0.00 sec)

I'm trying to create a database user for Drupal, but am not having any
luck. Help for a MySQL newb is very much appreciated.

This is on jessie with MySQL 5.5.



Try this:

$ mysql -h localhost -u user -p db_name

The '-p' indicates that you wish to be prompted for the password and
db_name is the name of the database you wish to connect to.

The choice of 'user' as your username might be problematic in some
circumstances since that is a reserved word in SQL.


 Hello,
 I don't know much about mysql myself, just started recently as
well, but I did find this help full ,

http://dev.mysql.com/doc/refman/5.7/en/create-user.html

Good luck

Re: MySQL access denied for user

[Liam O'Toole]

On 2016-08-15, Bill Wohler  wrote:
> I'm getting the following:
>
> $ mysql -h localhost -u user
> Enter password: 
> ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using 
> password: YES)
>
> This user was created with a fresh installation of mysql as (mysql) root
> with the following:
>
> mysql> create user 'user'@'localhost' identified by 'password';
> Query OK, 0 rows affected (0.00 sec)
> mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, 
> CREATE TEMPORARY TABLES ON database.* TO 'user'@'localhost' IDENTIFIED BY 
> 'password' with grant option;
> Query OK, 0 rows affected (0.00 sec)
>
> I'm trying to create a database user for Drupal, but am not having any
> luck. Help for a MySQL newb is very much appreciated.
>
> This is on jessie with MySQL 5.5.
>

Try this:

$ mysql -h localhost -u user -p db_name

The '-p' indicates that you wish to be prompted for the password and
db_name is the name of the database you wish to connect to.

The choice of 'user' as your username might be problematic in some
circumstances since that is a reserved word in SQL.

-- 

Liam

Re: MySQL access denied for user

[Joe]

On Sun, 14 Aug 2016 22:17:12 -0700
Bill Wohler  wrote:

> Bill Wohler  wrote:
> 
> > I'm getting the following:
> > 
> > $ mysql -h localhost -u user
> > Enter password: 
> > ERROR 1045 (28000): Access denied for user
> > 'user'@'localhost' (using password: YES)
> > 
> > This user was created with a fresh installation of mysql as (mysql)
> > root with the following:
> >   
> > mysql> create user 'user'@'localhost' identified by 'password';  
> > Query OK, 0 rows affected (0.00 sec)  
> > mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
> > mysql> ALTER, CREATE TEMPORARY TABLES ON database.* TO
> > mysql> 'user'@'localhost' IDENTIFIED BY 'password' with grant
> > mysql> option;  
> > Query OK, 0 rows affected (0.00 sec)
> > 
> > I'm trying to create a database user for Drupal, but am not having
> > any luck. Help for a MySQL newb is very much appreciated.  
> 
> I should point out that I've installed Drupal 8 from drupal.org since
> that isn't available to jessie (to my knowledge). I'd much prefer to
> say aptitude install drupal8 and get on with my web site rather than
> fight battles with mysql for literally days.
> 
> > This is on jessie with MySQL 5.5.

No exact answer, it's a long time since I did this kind of thing, you
might have more success on a MySQL forum. I've been using phpmyadmin
for many years, which I find much easier, especially in creating new
users and assigning particular database privileges. I do remember
the same kind of trouble as you are having, and eventually getting the
incantation exactly right.

-- 
Joe

Re: MySQL access denied for user

[Bill Wohler]

Bill Wohler  wrote:

> I'm getting the following:
> 
> $ mysql -h localhost -u user
> Enter password: 
> ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using 
> password: YES)
> 
> This user was created with a fresh installation of mysql as (mysql) root
> with the following:
> 
> mysql> create user 'user'@'localhost' identified by 'password';
> Query OK, 0 rows affected (0.00 sec)
> mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, 
> CREATE TEMPORARY TABLES ON database.* TO 'user'@'localhost' IDENTIFIED BY 
> 'password' with grant option;
> Query OK, 0 rows affected (0.00 sec)
> 
> I'm trying to create a database user for Drupal, but am not having any
> luck. Help for a MySQL newb is very much appreciated.

I should point out that I've installed Drupal 8 from drupal.org since
that isn't available to jessie (to my knowledge). I'd much prefer to say
aptitude install drupal8 and get on with my web site rather than fight
battles with mysql for literally days.

> This is on jessie with MySQL 5.5.
> 
> -- 
> Bill Wohler  aka 
> http://www.newt.com/wohler/
> GnuPG ID:610BD9AD

-- 
Bill Wohler  aka 
http://www.newt.com/wohler/
GnuPG ID:610BD9AD

MySQL access denied for user

[Bill Wohler]

I'm getting the following:

$ mysql -h localhost -u user
Enter password: 
ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using 
password: YES)

This user was created with a fresh installation of mysql as (mysql) root
with the following:

mysql> create user 'user'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE 
TEMPORARY TABLES ON database.* TO 'user'@'localhost' IDENTIFIED BY 'password' 
with grant option;
Query OK, 0 rows affected (0.00 sec)

I'm trying to create a database user for Drupal, but am not having any
luck. Help for a MySQL newb is very much appreciated.

This is on jessie with MySQL 5.5.

-- 
Bill Wohler  aka 
http://www.newt.com/wohler/
GnuPG ID:610BD9AD

phpmyadmin i mysql: Access denied for user [EMAIL PROTECTED] (using password: NO)

[Rafal Dabrowa]

Witam !

Zainstalowalem ze zrodel na tym samym serwerze:
apache_1.3.33
mod_ssl-2.8.22-1.3.33
mysql-4.1.11
phpMyAdmin-2.5.6

logowanie z konsoli serwera lokalnie do mysql'a na konto roota i usera
dziala bez zarzutu, co wskazuje ze hasla sa prawidlowo ustawione.

Problem sie zaczyna jezeli chce sie polaczyc z hosta 192.168.10.1 lub
innego przez phpmyadmina na serwer.

serwer mysql nasluchuje na porcie 3306/tcp

Probuje sie zalogowac do bazy snort z hosta 192.168.10.1 przez phpmyadmin
i zawsze dostaje komunikat :

#1045 - Access denied for user 'rafal'@'localhost' (using password: NO)

Prawidlowo podaje uzytkownia rafal i haslo.
Zastanawia mnie dlaczego wywala (using password: NO) skoro podaje tam
haslo!!!
Sprawdzilem tez dla opcji auth_type = config, http - tez
nie moge sie zalogowac

Identyczny komunikat dosteje probujac sie logowac z konsoli serwera bez
podania
hasla:

/usr/local/mysql/bin/mysql -u rafal -p

ERROR 1045 (28000): Access denied for user 'rafal'@'localhost' (using
password: NO)

jesli podam haslo to loguje sie bez problemu.

KONFIGURACJA.

w pliku my.cnf mama zahashowana opcje #skip-networking

W pliku config.inc.php mam:

$cfg['blowfish_secret'] = 'fsfsdfdsfsrwerwe';
$cfg['Servers'][$i]['host']  = 'localhost';
$cfg['Servers'][$i]['port']  = '3306';
$cfg['Servers'][$i]['socket']= '';
$cfg['Servers'][$i]['connect_type']  = 'tcp';
$cfg['Servers'][$i]['compress']  = FALSE;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user']  = '';
$cfg['Servers'][$i]['password']  = '';
$cfg['Servers'][$i]['only_db']   = 'snort';

Zawartosc tabeli mysql.user

mysql select Host,User from user;
+--++
| Host | User   |
+--++
| %| rafal  |
| 192.168.10.1 | rafal  |
| localhost| root   |
| localhost| rafal  |
+--++

Zawartosc tabeli mysql.db

mysql select Host,Db,User,Select_priv from db;
+--+---+---+-+
| Host | Db| User  | Select_priv |
+--+---+---+-+
| localhost| snort | rafal | Y   |
| %| snort | rafal | Y   |
| 192.168.10.1 | snort | rafal | Y   |
+--+---+---+-+

Zawartosc tabeli host jest pusta

mysql select * from host;
Empty set (0.01 sec)

Probuje sie zalogowac do bazy snort z hosta 192.168.10.1 przez phpmyadmin
i zawsze dostaje komunikat :

#1045 - Access denied for user 'rafal'@'localhost' (using password: NO)

Prawidlowo podaje uzytkownia rafal i haslo.
Zastanawia mnie dlaczego wywala (using password: NO) skoro podaje tam
haslo!!!
Sprawdzilem tez dla opcji auth_type = config, http - tez
nie moge sie zalogowac

Identyczny komunikat dosteje probujac sie logowac z konsoli bez podania
hasla:

/usr/local/mysql/bin/mysql -u rafal -p

ERROR 1045 (28000): Access denied for user 'rafal'@'localhost' (using password: 
NO)

Spotkal sie ktos z podobnym problemem ??

Pozdrawiam

Rafal


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]

Re: phpmyadmin i mysql: Access denied for user [EMAIL PROTECTED] (using password: NO)

[ma_zak]

On Sat, 7 May 2005, Rafal Dabrowa wrote:
 (...)
 Problem sie zaczyna jezeli chce sie polaczyc z hosta 192.168.10.1 lub
 innego przez phpmyadmina na serwer.
 (...)
 /usr/local/mysql/bin/mysql -u rafal -p

 ERROR 1045 (28000): Access denied for user 'rafal'@'localhost' (using
 password: NO)


Nie jestem pewien czy dobrze rozumiem - czy to nie jest tak, e
uruchamiasz klienta na komputerze 192.168.10.1 i prbujesz si
poczy z lokalnym (dla tego kompa) serwerem mysql
tj. serwerem dziaajcym na maszynie 192.168.10.1 ?

Sprbuj posuy si parameterem -h ip-serwera-mysql w wywoaniu
klienta mysql czyli:

/usr/local/mysql/bin/mysql -h ip-serwera-mysql -u rafal -p

--
Pozdrawiam
Marek
 Korzystanie z wolnego oprogramowania nie czyni wolnym,
ale korzystanie z kradzionego zniewala...

RE: phpmyadmin i mysql: Access denied for user [EMAIL PROTECTED] (using password: NO)

[Rafał Dąbrowa]

Serwer WWW+mysql mam na serwerze z IP 192.168.10.4 . Mam stworzonego
uytkownika w systemie rafal i w jego katalogu /home/rafal/public_html mam
phpmyadmina. Na apache'u mam ustawionego virtualhosta z adresu 192.168.10.4
wskazujacego na katalog /home/rafal/public_html w ktrym mam phpmyadmina

Jeeli loguje si lokalnie z terminala na serwerze do mysql'a na uytkownika
rafal to wszystko jest OKI. Np.

/usr/local/mysql/bin/mysql -u rafal -p

Dziala bez zarzutu.

Natomiast jak chce z hosta 192.168.10.1 zalogowac si na uytkownika rafal
przez WWW, podajc http://192.168.10.4, wyswietla mi si okno logowania do
phpmyadmina, natomiast po podaniu loginu i hasla dostaje zawsze komunikat

#1045 - Access denied for user 'rafal'@'localhost' (using password: NO)

Zauwayem, e jeeli jako root w mysql'u cign haso z tabeli mysql.user
dla uytkownika rafal i hosta localhost, 

+--++---+
| Host | User   | Password  |
+--++---+
| localhost| root   | * |
| localhost| rafal  |   |
| %| rafal  | * |
| 192.168.10.1 | rafal  | * |
+--++---+

to mog si zalogowac z hosta 192.168.10.1 przez WWW do phpmyadmina 

i dostaje komunikat

MySQL 4.1.11-log uruchomiony na localhost:3306, uytkownik [EMAIL PROTECTED]


Cos robie zle, ale jeszcze nie wiem co

Pozdrawiam
Rafal


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Saturday, May 07, 2005 10:36 PM
To: Rafal Dabrowa
Cc: debian-user-polish@lists.debian.org
Subject: Re: phpmyadmin i mysql: Access denied for user [EMAIL PROTECTED]
(using password: NO)

On Sat, 7 May 2005, Rafal Dabrowa wrote:
 (...)
 Problem sie zaczyna jezeli chce sie polaczyc z hosta 192.168.10.1 lub
 innego przez phpmyadmina na serwer.
 (...)
 /usr/local/mysql/bin/mysql -u rafal -p

 ERROR 1045 (28000): Access denied for user 'rafal'@'localhost' (using
 password: NO)


Nie jestem pewien czy dobrze rozumiem - czy to nie jest tak, e
uruchamiasz klienta na komputerze 192.168.10.1 i prbujesz si
poczy z lokalnym (dla tego kompa) serwerem mysql
tj. serwerem dziaajcym na maszynie 192.168.10.1 ?

Sprbuj posuy si parameterem -h ip-serwera-mysql w wywoaniu
klienta mysql czyli:

/usr/local/mysql/bin/mysql -h ip-serwera-mysql -u rafal -p

--
Pozdrawiam
Marek
 Korzystanie z wolnego oprogramowania nie czyni wolnym,
ale korzystanie z kradzionego zniewala...

Re: phpmyadmin i mysql: Access denied for user [EMAIL PROTECTED] (using password: NO) - errata :)

[Michał Prokopiuk]

On Sun, 8 May 2005 00:43:07 +0200, Micha Prokopiuk wrote
 On Sat, 7 May 2005 22:35:51 +0200 (CEST), ma_zak wrote
  On Sat, 7 May 2005, Rafal Dabrowa wrote:
   (...)
   Problem sie zaczyna jezeli chce sie polaczyc z hosta 192.168.10.1 lub
   innego przez phpmyadmina na serwer.
   (...)
   /usr/local/mysql/bin/mysql -u rafal -p
  
   ERROR 1045 (28000): Access denied for user 'rafal'@'localhost' (using
   password: NO)
 
 Zrozumialem, ze logujes sie do serwera zdalnie. Blokowac sie wiec 
 mozesz na wielu poziomach: - nie wylaczyles opcji nolisten tcp - 
 domyslnie w debianie ona jest, zahaszuj w /etc/mysql/my.cnf 

Oczywiscie nie nolisten tcp tylko skip networking :D Mialem ostatnio iksy i
siec na topie i sie zasugerowalem :)



Pozdrawiam
Micha Prokopiuk

-- 
mailto: [EMAIL PROTECTED]
http://www.sklep.linuxstuff.pl


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]