Sponsor:
Server and Web Integrator
Link:
6.5.0
or
7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR
is open-source.
Donate and or Sponsorship always welcome.
Click to:
Donate...
MRatWork
Forum
Please
login
or
register
.
2024-05-28, 15:28:31
Home
Help
Search
Calendar
Login
Register
MRatWork Forum by Mustafa Ramadhan
»
Sawo Project - Kloxo-MR Discussions
»
Kloxo-MR Technical Helps
»
Facing error to create new db Could not connect to DB [Access denied for user
« previous
next »
Print
Pages: [
1
]
Go Down
Author
Topic: Facing error to create new db Could not connect to DB [Access denied for user (Read 16958 times)
0 Members and 1 Guest are viewing this topic.
amitkumar
Valuable Member
Posts: 121
Karma: +1/-1
Gender:
Facing error to create new db Could not connect to DB [Access denied for user
«
on:
2018-04-04, 10:23:38 »
hi
[root@server ~]# sh /script/reset-mysql-root-password XXXXXXXXxx
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
[1]- Done mysqld_safe --skip-grant-tables
but still i am facing error while creating New DB Could not connect to DB [Access denied for user 'root'@'localhost' (using password: YES)]...
[root@server ~]# sh /script/sysinfo
A. Control Panel:
- Kloxo-MR: 7.0.0.c-2017091202
- Web: hiawatha-10.6.0-f.1.mr.el7.x86_64
- PHP: php56s - 5.6.30-2.ius.centos7 (fpm mode)
B. Plateform:
- OS: CentOS Linux release 7.4.1708 (Core) x86_64
- Hostname: server.xxxx.com
C. Services:
1. MySQL: --uninstalled--
2. PHP:
- Installed:
- Branch: --uninstalled--
- Multiple:
* php54m - 5.4.45-14.mr.el7
* php55m - 5.5.38-1.ius.centos7
* php56m - 5.6.30-2.ius.centos7
* php70m - 7.0.25-1.ius.centos7
* php71m - 7.1.11-1.ius.centos7
- Used: php56m-fpm
- Multiple: enable
3. Web Used: apache
- Hiawatha: hiawatha-10.6.0-f.1.mr.el7.x86_64
- Lighttpd: lighttpd-1.4.47-1.el7.x86_64
- Nginx: nginx-1.13.6-1.el7_4.ngx.x86_64
- Apache: httpd24u-2.4.29-1.ius.centos7.x86_64
- PHP Type: php-fpm_event
- Secondary PHP: on
4. WebCache: none
- ATS: --uninstalled--
- Squid: --uninstalled--
- Varnish: --uninstalled--
5. Dns: nsd
- Bind: bind-9.9.9-1.mr.el7.x86_64
- DJBDns: djbdns-1.05-17.4.mr.el7.x86_64
- NSD: nsd-4.1.16-1.el7.x86_64
- PowerDNS: pdns-4.0.3-1.el7.MIND.x86_64
- Yadifa: yadifa-2.2.6-1.el7.x86_64
6. Mail: qmail-toaster-1.03-1.3.57.mr.el7.x86_64
- pop3/imap4: courier-imap-toaster-4.1.2-1.3.20.mr.el7.x86_64
- smtp: qmail-toaster-1.03-1.3.57.mr.el7.x86_64
- spam: bogofilter-1.2.3-6.el7.x86_64
7. FTP: pure-ftpd
- pure-ftpd: pure-ftpd-1.0.42-3.el7.x86_64
8. Stats: awstats
- awstats: kloxomr-stats-awstats-7.6-1.mr.noarch
D. Memory:
total used free shared buff/cache available
Mem: 7877 740 5222 42 1914 7021
Swap: 1021 0 1021
E. Disk Space:
Filesystem Size Used Avail Use% Mounted on
/dev/root 39G 5.2G 32G 15% /
Logged
amitkumar
Valuable Member
Posts: 121
Karma: +1/-1
Gender:
Re: Facing error to create new db Could not connect to DB [Access denied for user
«
Reply #1 on:
2018-04-04, 10:49:18 »
Solved
https://tecadmin.net/steps-to-reset-mariadb-root-password-in-linux/
even can see more details at
https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password
just follow the process
Logged
fossxplorer
Master
Posts: 640
Karma: +1/-0
Re: Facing error to create new db Could not connect to DB [Access denied for user
«
Reply #2 on:
2018-04-05, 10:21:12 »
I think this is something i discussed with MR to be included, since AFAIK and IIRC, you need to specify the user (root in this case, otherwise user mysql will be used) when running that mysqld_safe command.
I had the same issue on CentOS 7.
Logged
Kloxo-MR!
Print
Pages: [
1
]
Go Up
« previous
next »
MRatWork Forum by Mustafa Ramadhan
»
Sawo Project - Kloxo-MR Discussions
»
Kloxo-MR Technical Helps
»
Facing error to create new db Could not connect to DB [Access denied for user
Top 4 Global Search Engines:
Google
Bing
Baidu
Yahoo
Design By SMFSimple.com
SMF 2.0.15
|
SMF © 2017
,
Simple Machines
Page created in 0.053 seconds with 21 queries.