Welcome Guest. Please Login or Register  
Client Area  |  Softaculous Cloud  |  Calendar  |  Quick Links  |  
   


You are here: Index > Webuzo > General Support > Topic : Database Missing???



Threaded Mode | Print  

 Database Missing???, Database Missing on Webuzo Panel (13 Replies, Read 10402 times)
andiklive
Posted on # January 2, 2015, 11:47 am
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
Hello,
my database missing on panel but database still can connect with normal user.
but not working for root, i just login it via console but it noticed failed to login.

i got password from /var/webuzo/my.conf
and login it with that password but failed,
#mysql -u root -pmypassword
and got message
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
its look like root user dont have privillage for mysql database, how can its happen and possible???

it look like another user got same problem with me, and its fixed by submit ticket.
i know change /var/webuzo/my.conf password not actually change the real password.
im glad if you can give me some tips or guide, so i love to fix it by myself.

thanks for your time to read my thread and hope someone can help me.
thanks

-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

Database Missing???
valley
Posted on # January 5, 2015, 7:13 am | Post: 1
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Hi,

You can refer to this guide
http://www.rackspace.com/knowledge_center/article/mysql-resetting-a-lost-mysql-root-password

Hope it helps :)

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

Database Missing???
andiklive
Posted on # January 5, 2015, 9:50 am | Post: 2
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
prevoiusly i just try it this method, and no luck with that.
here in my console, i use centos 6.5 x64 anyway

PHP Code

 [root@server public_html]# sudo /etc/init.d/mysqld stop
Shutting down MySQL.. SUCCESS! 
[root@server public_html]# sudo mysqld_safe --skip-grant-tables &
[1] 13262
[root@server public_html]# 150105 04:41:12 mysqld_safe Logging to '/var/log/mysqld.log'.
150105 04:41:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150105 04:41:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[1]+  Done                    sudo mysqld_safe --skip-grant-tables
[root@server public_html]# sudo /etc/init.d/mysqld start
Starting MySQL.. SUCCESS! 
[root@server public_html]# 



any suggestion???

-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

Database Missing???
valley
Posted on # January 5, 2015, 10:01 am | Post: 3
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Check the logs located at /var/logs

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

Database Missing???
andiklive
Posted on # January 5, 2015, 10:04 am | Post: 4
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
here my mysql logs, i dont know to analize it anyway :D

PHP Code

 [root@server public_html]# tail -c 5k /var/log/mysqld.log
150102  7:14:18 [Warning] IP address '198.13.107.104' could not be resolved: Temporary failure in name resolution
150103  8:55:52 [Warning] IP address '198.13.107.104' could not be resolved: Temporary failure in name resolution
150104  1:48:21 [Warning] IP address '61.147.103.160' could not be resolved: Name or service not known
150104  9:13:38 [Warning] IP address '61.147.103.161' could not be resolved: Name or service not known
150105  4:40:55 [Note] /usr/local/apps/mysql/bin/mysqld: Normal shutdown

150105  4:40:55 [Note] Event Scheduler: Purging the queue. 0 events
150105  4:40:55  InnoDB: Starting shutdown...
150105  4:40:57  InnoDB: Shutdown completed; log sequence number 225300891
150105  4:40:57 [Note] /usr/local/apps/mysql/bin/mysqld: Shutdown complete

150105 04:40:57 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
150105 04:41:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150105  4:41:12 InnoDB: The InnoDB memory heap is disabled
150105  4:41:12 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
150105  4:41:12 InnoDB: Compressed tables use zlib 1.2.3
150105  4:41:12 InnoDB: Initializing buffer pool, size = 128.0M
150105  4:41:12 InnoDB: Completed initialization of buffer pool
150105  4:41:12 InnoDB: highest supported file format is Barracuda.
150105  4:41:12  InnoDB: Waiting for the background threads to start
150105  4:41:13 InnoDB: 5.5.40 started; log sequence number 225300891
150105  4:41:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150105  4:41:13 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
150105  4:41:13 [Note] Server socket created on IP: '0.0.0.0'.
150105  4:41:13 [ERROR] /usr/local/apps/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
150105  4:41:13 [ERROR] Can't start server: can't create PID file: No such file or directory
150105 04:41:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150105 04:43:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150105  4:43:15 InnoDB: The InnoDB memory heap is disabled
150105  4:43:15 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
150105  4:43:15 InnoDB: Compressed tables use zlib 1.2.3
150105  4:43:15 InnoDB: Initializing buffer pool, size = 128.0M
150105  4:43:15 InnoDB: Completed initialization of buffer pool
150105  4:43:15 InnoDB: highest supported file format is Barracuda.
150105  4:43:15  InnoDB: Waiting for the background threads to start
150105  4:43:16 InnoDB: 5.5.40 started; log sequence number 225300891
150105  4:43:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150105  4:43:16 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
150105  4:43:16 [Note] Server socket created on IP: '0.0.0.0'.
150105  4:43:16 [ERROR] /usr/local/apps/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
150105  4:43:16 [ERROR] Can't start server: can't create PID file: No such file or directory
150105 04:43:16 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150105 04:43:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150105  4:43:56 InnoDB: The InnoDB memory heap is disabled
150105  4:43:56 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
150105  4:43:56 InnoDB: Compressed tables use zlib 1.2.3
150105  4:43:56 InnoDB: Initializing buffer pool, size = 128.0M
150105  4:43:56 InnoDB: Completed initialization of buffer pool
150105  4:43:56 InnoDB: highest supported file format is Barracuda.
150105  4:43:56  InnoDB: Waiting for the background threads to start
150105  4:43:57 InnoDB: 5.5.40 started; log sequence number 225300891
150105  4:43:57 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150105  4:43:57 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
150105  4:43:57 [Note] Server socket created on IP: '0.0.0.0'.
150105  4:43:58 [Note] Event Scheduler: Loaded 0 events
150105  4:43:58 [Note] /usr/local/apps/mysql/bin/mysqld: ready for connections.
Version: '5.5.40'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
[root@server public_html]# 



-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

Database Missing???
andiklive
Posted on # January 5, 2015, 10:26 am | Post: 5
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
logs path that youare provide not exist anyway

PHP Code

 [root@server public_html]# tail -f /var/logs
tail: cannot open `/var/logs' for reading: No such file or directory
tail: no files remaining
[root@server public_html]# 



-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

Database Missing???
valley
Posted on # January 7, 2015, 6:11 am | Post: 6
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Create the file /var/run/mysqld and set owner and group as "mysql"

Hope this helps :)

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

Database Missing???
andiklive
Posted on # January 7, 2015, 10:35 am | Post: 7
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
Quote From : valley January 7, 2015, 6:11 am
Create the file /var/run/mysqld and set owner and group as "mysql"

Hope this helps :)


Many thanks, awesome support.

now its solved!  :xd:

-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

Database Missing???
valley
Posted on # January 8, 2015, 11:57 am | Post: 8
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Glad to learn it worked for you :D

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

Database Missing???
doganmanis
Posted on # June 1, 2015, 1:48 pm | Post: 9
Group: Member
Post Group: Newbie
Posts: 6
Status:
Quote From : valley January 7, 2015, 6:11 am
Create the file /var/run/mysqld and set owner and group as "mysql"

Hope this helps :)


how to create the file?
i have the same prob
IP: --   

Database Missing???
valley
Posted on # June 1, 2015, 3:02 pm | Post: 10
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Quote From : doganmanis June 1, 2015, 1:48 pm
Quote From : valley January 7, 2015, 6:11 am
Create the file /var/run/mysqld and set owner and group as "mysql"

Hope this helps :)


how to create the file?
i have the same prob


The following 2 commands should do the trick.
mkdir /var/run/mysqld

chown mysql:mysql /var/run/mysqld

Note : Make sure you are logged in as root to be able to execute the above commands.

Hope this helps :)




-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

Database Missing???
doganmanis
Posted on # June 2, 2015, 2:08 am | Post: 11
Group: Member
Post Group: Newbie
Posts: 6
Status:
Quote From : valley June 1, 2015, 3:02 pm
Quote From : doganmanis June 1, 2015, 1:48 pm
Quote From : valley January 7, 2015, 6:11 am
Create the file /var/run/mysqld and set owner and group as "mysql"

Hope this helps :)


how to create the file?
i have the same prob


The following 2 commands should do the trick.
mkdir /var/run/mysqld

chown mysql:mysql /var/run/mysqld

Note : Make sure you are logged in as root to be able to execute the above commands.

Hope this helps :)




no luck for me :(
i got error mysql pid file cannot start/missing something like that
i try to remove mariadb then reinstall again but nothing change :(

this is my server error

PHP Code

 InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
150601 21:56:07 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 5.5.42-MariaDB
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 465688 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x48000
mysys/stacktrace.c:246(my_print_stacktrace)[0x865c52d]
sql/signal_handler.cc:153(handle_fatal_signal)[0x82da7eb]
[0xb76e6500]
/lib/libc.so.6(abort+0x17a)[0xb73e83ea]
btr/btr0btr.c:3383(btr_compress)[0x855f04a]
btr/btr0cur.c:3222(btr_cur_compress_if_useful)[0x85641af]
btr/btr0cur.c:3471(btr_cur_pessimistic_delete)[0x856f7b1]
row/row0purge.c:177(row_purge_remove_clust_if_poss_low)[0x86295a4]
row/row0purge.c:216(row_purge_remove_clust_if_poss)[0x862a086]
que/que0que.c:1259(que_thr_step)[0x861fdd8]
trx/trx0purge.c:1220(trx_purge)[0x853adad]
srv/srv0srv.c:4210(srv_purge_thread)[0x852e0dd]
/lib/libpthread.so.0(+0x6b39)[0xb76cbb39]
/lib/libc.so.6(clone+0x5e)[0xb749ed7e]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
150601 21:56:08 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended 



please someone help me
IP: --   

Database Missing???
danielpeterson
Posted on # June 2, 2015, 7:02 pm | Post: 12
Group: Member
Post Group: Newbie
Posts: 1
Status:
I have the same issue like @andiklive by following step by step your help i solved it. Thanks so much @valley

-----------------------
Are you looking for undercounter ice maker - portable ice maker?
IP: --   

Database Missing???
valley
Posted on # June 3, 2015, 8:32 am | Post: 13
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
@doganmanis do you have any databases on the server ? Do you have a backup of the databases ?

Please confirm, for I have another trick for you... But your existing MySQL data might go away :)

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is April 24, 2024, 12:48 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.022