All Questions
843
questions
21
votes
1
answer
5k
views
Why is mysqlserver.lib file very large? Is this file neccessary in wamp stack?
Recently I created my development server using php7.0.1, mysql5.7 and apache 2.4.20.
After I successfully got it running, I checked the file size of my server and found that it is almost 2 GB.
So I ...
- 371
17
votes
2
answers
43k
views
WARNING: Module mcrypt ini file doesn't exist under /etc/php/7.2/mods-available
I've been trying to install phpmyadmin in Ubuntu 16.04.3 LTS having a lamp installed, php 7.2, mysql Ver 15.1 Distrib 10.2.12-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 and apache2.
...
- 8,555
13
votes
7
answers
3k
views
serve content from file vs database in node
I am making a new version of a old static website that grew up to a 50+ static pages.
So I made a JSON file with the old content so the new website can be more CMS (with templates for common pages) ...
- 7,625
12
votes
2
answers
31k
views
How to get MySql 8 to run with laravel? [duplicate]
I'm having difficulty getting MySQL 8 to work. This is the error that appears everytime I attempt a php artisan migrate. I've reinstalled MySQL only once so far because I didn't want to hurt my head ...
- 1,867
11
votes
3
answers
2k
views
Auto save server architecture
I want to save a lengthy form's inputs at the server. But I don't think making db calls on each auto-save action is the best approach to go for.
What would constitute as a good approach to solve ...
- 10.1k
11
votes
1
answer
17k
views
protocol packets out of order
I recently uploaded my node.js app on A2 Hosting and I get this error :
{ Error: Packets out of order. Got: 80 Expected: 0
at Parser.write (/home/westudec/public_html/myapp/node_modules/mysql/...
- 324
11
votes
5
answers
41k
views
MySQL Installation MySQL Server Failed 5.7.19
Fail Image
During installation of MySQL msi installer this status of MySQL Server showed up, no idea how to fix.
My Operation System: Windows 7
- 119
10
votes
4
answers
5k
views
Where to save a single value on server
I am creating an application with a click to call button on an html page.
There will be one person manning the phone. I want this person to be able to set a variable with a boolean value on my ...
- 1,128
9
votes
2
answers
10k
views
Laravel Project ERR_EMPTY_RESPONSE
I am facing a very critical issue on server where i hosted a Laravel application project.I have some other projects hosted there. Some times I see "ERR_EMPTY_RESPONSE" error on browser. But at the ...
- 697
8
votes
1
answer
5k
views
Mysql installation ubuntu server: Could not open 'abstractions/mysql'
I wanted to configure remote access to my database. I could not configurate this and I decided to reinstall ssh and mysql. After reinstallation i have this error:
ERROR 2002 (HY000): Can't connect ...
- 81
7
votes
2
answers
12k
views
What is MySQL doing?? 100% disk utilization from boot
I have a large database on a Win10 machine, mysqld.exe does a lot of disk I/O, 100%, for hours and hours 100MB/s consistently - mostly writes - persists after numerous reboots. How can I find out what ...
- 773
7
votes
2
answers
1k
views
Localhost MySQL PHP Database Migration Slow Performance Compared To Virtualhost Homestead
[VIRTUAL HOST] Laravel Homestead database migration are so much faster than my [LOCALHOST] Laravel Valet / Vessel / XAMPP /?
Can anyone explain why? Or is there a way to enhance my localhosts speed?
- 2,913
6
votes
3
answers
17k
views
MySQL won't run when i am using XAMPP server
This is the error log for the MySQL when I run it on XAMPP. I don't know how to fix it, it's always stuck on attempting to start MySQL service..
I tried changing the port but the result is still the ...
- 89
6
votes
1
answer
17k
views
MySQL is not found anywhere on computer
I have recently installed MySQL directly from the website (mysql-5.7.9-osx10.10-x86_64.dmg) and I have run into a great deal of difficulty that started with trying to change the given password. The ...
6
votes
3
answers
5k
views
MySQL 5.7.9 on OS X El Capitan: ERROR The server quit without updating the PID file
I have a Mac Pro Server with OS X Yosemite, a few days ago we made an upgrade to OS X El Capitan. The problem arise when I try to reinstall MySQL. I went to the official MySQL page and download the ...
5
votes
2
answers
8k
views
Close mysql port : 3306 and make it local
When I'm trying to show the port that's opened in my server show to me the port : 3306 and this port for mysql database
How can I close mysql port (3306) and make it just for local connections mean ...
- 243
5
votes
2
answers
1k
views
What does the d mean in mysqld.exe
What does the "d" mean in mysqld.exe? I think I have seen it in other software, too. httpd, for example. They also use %d.exe to start the server.
- 1,052
5
votes
2
answers
4k
views
How to check SQL server version in Laravel blade view
How to check SQL server versions in Laravel blade file. I want make file system info.
Now i have this:
<div>Laravel version: {{ App::VERSION() }}</div>
<div>PHP version: @php echo ...
- 57
5
votes
1
answer
6k
views
Mysql replication error Last_IO_Error
We have existing server master to master replication on two server, and we not mentioned 11.12.13.18 ip in any where, but we are getting error like below.
Last_IO_Error: Master command ...
- 1,976
5
votes
2
answers
327
views
How do popular Android apps connect to a server? [closed]
I usually connect to a remote MySQL database from an android device using a PHP script to manage the database, run this script using the HTTP protocol and code data in JSON format. I am now looking ...
- 103
5
votes
4
answers
19k
views
Error during installation - Database initialization failed [closed]
During the final step of the installation of MySQLServer (Apply Configurations), I get a strange error. I can't get it. Here's the Log :
Attempting to add a Windows Firewall rule with command: netsh....
- 188
4
votes
3
answers
6k
views
connection error between two devices: ImportError: libmariadb.so.3: cannot open shared object file: No such file or directory
I have two devices that I use as MySql server and Django server. My system, which works on my development device, becomes inoperable when it switches to other devices. Settings on 192.168.3.60:
...
- 61
4
votes
1
answer
16k
views
How to connect or link to localhost server address in Android Studio
I am following a tutorial of making a login register for android by tonakami TV in youtube, I encountered a problem where the android app can't update or connect to the database via LOCALHOST XAMPP. ...
- 118
4
votes
2
answers
6k
views
How to make a request to localhost via iOS device (using Xcode)?
I have a localhost website up at localhost:1336. When I run it on my simulator using Xcode, the app does not encounter any problem make a request to the localhost for data. But when I connect my ...
- 91
4
votes
1
answer
484
views
Swift Asynchronous Data Display Lag
I am having some difficulty with an asynchronous data fetch from a server (MySQL database which I access through some PHP web services). My code is below:
func RetreiveStaff() {
SetProgramMode()
...
- 1,501
4
votes
1
answer
4k
views
Receiving PHP Warning: Module '[module name]' already loaded in Unknown on line 0
I'm Trying to learn Laravel and PHP while learning how to manage a server. I was trying to fix a different problem, something about a PDO driver not being found when trying to read from a sqlite ...
- 175
3
votes
3
answers
8k
views
Cannot uninstall mysql-server-8.0
after installing mariadb with mysql already installed, i had issues and mysql wasent working so i tried to uninstall mysql and the package broke.
after frustrating hours of trying to fix this i ...
- 31
3
votes
2
answers
4k
views
Using Read Replica Promotion to Create Index On AWS RDS MySQL Database
I would like to add an index to a MySQL table in a database on Amazon RDS, but I do not want to stop using the database while the index is created. This answer suggests using read replica promotion, ...
- 13.5k
3
votes
4
answers
4k
views
Sending messages from Server to Android App
I have an app that displays messages stored in a MySQL database. Right now, the user has to press a button to trigger a download of the messages to his or her phone. I want to implement the feature ...
- 81
3
votes
2
answers
3k
views
Connecting MySQL Server 8.0 using C#
I'm trying to connect MySQL Server 8.0 running on windows to C#. Before this, I was using PhpMyAdmin but now I've installed MySql 8.0 Command Line Client and I want to connect my program with it. It ...
- 119
3
votes
2
answers
41
views
Failed to show the result
For my project i am using PHP and MySql. In that i was tried to upload an image to the mysql database. In that i faced one terrible error. My html code was like this
<!doctype html>
<html>...
- 65
3
votes
3
answers
9k
views
Digital Ocean, connect to database with mySQL workbench
I just started digital ocean server running ubuntu 14.04 LAMP server. I used my droplets IP address, root as the user and port 3306. I typed in the right password, but I can not for the life of me ...
- 6,811
3
votes
1
answer
2k
views
How do i start mysql service in recovery mode from mounted hdd
I had a server crash and mounted my disk to /mnt/
I made a backup of all datas for now just to be sure, but really need my mysql database with structure and datas.
I thought maybe its the easiest ...
- 113
3
votes
3
answers
6k
views
How do I turn on query_cache on a Windows XAMPP Server?
In xampp/mysql/bin/my.ini
Do I add?
query_cache_size = 16777216
query_cache_type = 1
query_cache_limit = 1048576
I have tried the above and restarted mysql server but when I run this query:
SHOW ...
- 1,101
3
votes
2
answers
2k
views
How to create random unique (not repeated) and fix length (9 digits) primary key in mysql database?
As the title, how to create a 9 digits number primary key which is random, unique, not repeated and from range 100000000 to 999999999?
And this method must be work on the godaddy server, seems ...
- 147
3
votes
1
answer
202
views
I cannot seem to connect my PHP page to my SQL test server and database
What I would like to happen is for a user to fill out a form and that information be sent to a database. I am using html and php in dreamweaver, and WAM with phpMyAdmin.
I have tried everything and ...
- 123
3
votes
2
answers
11k
views
Connect to remote MySQL via Python
I have installed MySQL on a remote server. I also created some databases with some tables in them, all via SSH.
I have created the following users:
CREATE USER 'myname'@'localhost' IDENTIFIED BY '...
- 11.6k
3
votes
2
answers
4k
views
MySQL/PHP site extremely slow after server 'upgrade' - PHP version issues?
We have just upgraded our dedicated web server through our hosting company from a 3 year old dual core, 8GB Plesk machine running PHP 5.1 and MySQL 5.1.
New server is 6 core, 8GB cPanel/WHM server ...
- 31
3
votes
1
answer
3k
views
mysqld is getting killed by own
I don't know what process is killing it. I have zero experience in CentOS. First it was not starting using
service mysqld start
And showing error
/usr/bin/mysqld_safe: line 183: 7618 Killed ...
- 9,620
3
votes
1
answer
3k
views
How to change session.gc_maxlifetime?
After setting $cfg['LoginCookieValidity'] = 604880; for phpMyAdmin, I'm getting the following warning in phpMyAdmin:
Your PHP parameter session.gc_maxlifetime is lower than cookie
validity ...
user6792802
3
votes
2
answers
181
views
What's the procedure of upload a java spring based web application to the real server, and how to use load balance to the server?
I am creating a simple web project with mysql database using Java Spring-MVC. Now I want to understand the full workflow of the web system development cycle.
How to upload a project to a real server?....
3
votes
2
answers
12k
views
Mysql high cpu usage (over 600%)
here is my mysql configuration file:
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-...
- 33
3
votes
3
answers
2k
views
image file success upload in localhost, but it can't in server using CI
When i try upload image files in localhost it stored on DB and i can read that uploaded images, but when i upload the code to the server via FTP it said error like this:
This page isn’t working
...
- 43
3
votes
1
answer
3k
views
Best practice: Connect WPF to remote SQL database
I know that there are a lot of questions regarding this topic, however after four days of reading and googling, I am kind of stuck and need somebody to clarify some things for me please.
My situation:...
- 329
3
votes
2
answers
2k
views
Whats a DBMS... Confused [closed]
I'm on a big doubt, Whats really a DBMS. Is it the Client who manages the database server? Or is it the Server...
Is it Mysql Workbench the DBMS or is it the MYSQL Server.
Please if you could help,...
3
votes
1
answer
2k
views
Update mysql timezone and change all TIMESTAMPS columns
First of all I have MYSQL set to America/Montreal
SET time_zone = 'America/Montreal
to make sure it all works fine I use in PHP:
date_default_timezone_set('America/Montreal');
Something I don't ...
- 9,466
3
votes
1
answer
9k
views
Optimize Wordpress image upload, slow and only 1 at a time on Dedicated
So I have been at this for weeks with different configurations and I usually am able to figure out by searching but I am not as savvy with server configuration, so I need to ask. Hopefully someone can ...
3
votes
2
answers
638
views
Python MySQL-Connector failing to connect intermittently on Windows VPS
I am scraping data using a Windows VPS. I am using Python MySQL-Connector to upload this scraped data to a Linux dedicated server.
import mysql.connector
mydb = mysql.connector.connect(
...
- 578
3
votes
0
answers
4k
views
mysql.service: Main process exited, code=exited, status=1/FAILURE
i cannot start my mysql server, it crashed all a sudden and i can not find any useful log to say why.
my disk has still some space left, several Gigabytes.
last logs from journalctl -feu mysql are ...
- 749
3
votes
1
answer
2k
views
MySQL Keeps shutting down
I am having an issue regarding my MySQL Database.
I have a program which has a mild to heavy traffic per day. It was working well before but these past few days it keeps on shutting and the server ...
- 327